GoodsID Num
A 4
B 2
C 1
A 3
B 4
C 3
我想得到:
GoodsID Count
A 7
B 6
C 4
用SQL Server语句如何实现?恳请行家高手不吝惜指点!万分感谢!!
GoodsID Num
A 4
B 2
C 1
A 3
B 4
C 3
我想得到:
GoodsID Count
A 7
B 6
C 4
用SQL Server语句如何实现?恳请行家高手不吝惜指点!万分感谢!!
select GoodsID, sum(Num) as Count from table
group by GoodsID