SQL 行转列
时间：2022-03-15 12:18
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
