原始数据:select * from date_tab;
目标格式:
解法一:
select year,
Sum(case when month =1 then amount end) as m1,
Sum(Case when month=2 then amount end) as m2,
Sum(Case when month=3 then amount end) as m3,
Sum(Case when month=4 then amount end) as m4
from DATE_TAB group by year;
解法二:
select * from date_tab pivot (sum(amount) for month in (1 as m1,2 as m2,3 as m3,4 as m4));