67,513
社区成员
发帖
与我相关
我的任务
分享
select t.shop,sum(t.show1) '1',sum(t.show2) '2',sum(t.show3) '3',sum(t.show4) '4' from (select g.shop,case when g.good= 1 then sum(g.sum) else 0 end show1,
case when g.good= 2 then sum(g.sum) else 0 end show2,
case when g.good= 3 then sum(g.sum) else 0 end show3,
case when g.good= 4 then sum(g.sum) else 0 end show4
from good_inf as g group by g.shop,g.good) t group by t.shop