34,594
社区成员
发帖
与我相关
我的任务
分享
declare @T table([EmpCode] varchar(20),[Quantity] int,[ItemModel] varchar(20))
Insert @T
select '张三',300,'A' union all
select '李四',150,'A' union all
select '赵五',200,'B'
select EmpCode,
A =sum(case when ItemModel='A' then Quantity else 0 end),
B =sum(case when ItemModel='B' then Quantity else 0 end)
from @T
group by EmpCode