行转列小练习

原始数据：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));