1 select * from Score
1 select student, 2 sum(case course when ‘语文‘ then score end) as ‘语文‘, 3 sum(case course when ‘数学‘ then score end) as ‘数学‘, 4 sum(case course when ‘英语‘ then score end) as ‘英语‘ 5 from Score 6 group by student
原文：https://www.cnblogs.com/flyer2018/p/10130715.html