SQL行转列

 select * from Score 

select student,
sum(case course when '语文' then score end) as '语文',
sum(case course when '数学' then score end) as '数学',
sum(case course when '英语' then score end) as '英语'
from Score 
group by student