SQL_视图_对视图中某几个字段汇总

对视图中某几个字段汇总

SELECT MATNR,
sum(PO_QTY) AS PO_QTY,
sum(TOTAL_QTY) AS TOTAL_QTY,
sum(SURPLUS_QTY) AS SURPLUS_QTY,
max(THPRTIME) AS THPRTIME,
sum(RESULT) AS RESULT
FROM dbo.v_Exp_RecordBable_RawEdge GROUP BY MATNR