SQL 行转列

 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