很难解释我要做什么(很抱歉标题难以理解),但是基本上我想像这样对重复行求和:
表A:
EntryID| Country | Region | Sales
101 | USA | North | $10
102 | USA | North | $5
103 | USA | South | $15
104 | USA | South | $10
105 | CHINA | North | $5
106 | CHINA | North | $5
107 | CHINA | South | $10
108 | CHINA | South | $20
所需输出:
EntryID| Country | Region | Sales
101 | USA | North | $15
103 | USA | South | $25
105 | CHINA | North | $10
107 | CHINA | South | $30
我怎样才能做到这一点?
SQL语句必须看起来像:
SELECT MIN(EntryID) AS EntryID,
Country,
Region,
SUM(Sales) AS Sales
FROM TABLE
GROUP BY Country,
Region
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句