22,210
社区成员
发帖
与我相关
我的任务
分享
---测试数据---
declare @tb table(prodid varchar(10), prodname varchar(20), qty int, dw varchar(5))
insert @tb
select '001' , 'abc', 1, '臺' union all
select '002' , 'cb', 3, '條' union all
select '001' , 'ac', 2, '臺'
---查询---
select prodid , min(prodname) as prodname, sum(qty) as qty , min(dw) dw
from @tb
group by prodid
---结果---
prodid prodname qty dw
---------- -------------------- ----------- -----
001 abc 3 臺
002 cb 3 條
(所影响的行数为 2 行)
select prodid , max(prodname) prodname, sum(qty) qty , max(dw) dw from tb group by prodid
select prodid,prodname=max(prodname),qty=sum(qty),dw
from tb
group by prodid,dw