■

メモメモ

select
名前,
sum(case when 月=1 then 金額 else 0 end) as １月,
sum(case when 月=2 then 金額 else 0 end) as ２月,
sum(case when 月=3 then 金額 else 0 end) as ３月,
sum(case when 月=4 then 金額 else 0 end) as ４月,
sum(case when 月=5 then 金額 else 0 end) as ５月,
sum(case when 月=6 then 金額 else 0 end) as ６月,
sum(case when 月=7 then 金額 else 0 end) as ７月,
sum(case when 月=8 then 金額 else 0 end) as ８月,
sum(case when 月=9 then 金額 else 0 end) as ９月,
sum(case when 月=10 then 金額 else 0 end) as １０月,
sum(case when 月=11 then 金額 else 0 end) as １１月,
sum(case when 月=12 then 金額 else 0 end) as １２月
from テーブル名
group by 名前