select year,
sum(case quarte
when 1 then salnum
end
) "一季度",
sum(case quarte
when 2 then salnum
end) "二季度",
sum(case quarte
when 3 then salnum
end) "三季度",
sum(case quarte
when 4 then salnum
end) "四季度"
sum(case quarte
when 1 then salnum
end
) "一季度",
sum(case quarte
when 2 then salnum
end) "二季度",
sum(case quarte
when 3 then salnum
end) "三季度",
sum(case quarte
when 4 then salnum
end) "四季度"
from sales group by year;
答案参考博客地址:http://blog.csdn.net/jackfrued/article/details/45021897