【每日一题】SQL 知识大测验 | 持续更新
32. SELECT year, sum(case when mounth = 1 then amount else '' end), sum(case when mounth = 2 then amount else '' end), sum(case when mounth = 3 then amount else '' end), sum(case when mounth = 4 then amount else '' end) FROM t32 GROUP BY year ;
赞2
踩0