问题
解答
select year,
sum(CASE t.month
WHEN 1 THEN
t.amount
end) m1,
sum(CASE t.month
WHEN 2 THEN
t.amount
end) m2,
sum(CASE t.month
WHEN 3 THEN
t.amount
end) m3,
sum(CASE t.month
WHEN 4 THEN
t.amount
end) m4
from tablename t
group by year;
CASE ....(要进行判断的值)
WHEN (判断条件,类似if)....THEN(满足则执行).....
......
ELSE(不满足则执行)
......
END(结束)
tablename t是问题图中假设已经给出的表名
用select查询year、m1、m2、m3、m4
用 sum()求和会新开一列并重新命名为m1
group by year 配合聚合函数sum()来用,按年份分组