select 部门,sum(产品1) as 产品1,sum(产品2) as 产品2,sum(产品3) as 产品3 from (select a as 部门,(case B when '产品1' then sum(c) else 0 end) as 产品1,(case B when '产品2' then sum(c) else 0 end) as 产品2,(case B when '产品3' then sum(c) else 0 end) as 产品3 from Table_2 group by A,b) as t group by 部门...
|