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