对视图中某几个字段汇总
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
标签:MATNR,SURPLUS,sum,汇总,视图,QTY,SQL From: https://www.cnblogs.com/automationanywhere/p/17984521