Question

关于SQL的sum多条件计算 求教高手

Answer 1

select name,
sum (case when sort1=1 and sort2=0 then num end) a,
sum (case when sort1=1 and sort2=1 then num end) b,
sum (case when sort1=2 and sort2=0 then num end) c,
sum (case when sort1=2 and sort2=1 then num end) d
from table1 group by name
我这测试了可以的！