sql将行转换成列

创建stu_score表如下图：

查询结果如下图

sql语句

select name as ‘姓名’，
max(case course when ‘高数’ then score else 0 end) as ‘高数’，
max(case course when ‘英语’ then score else 0 end) as ‘英语’,
max(case course when ‘c语言’ then score else 0 end) as ‘c语言’
from str_score group by name

• 如果没有group by name 则查询 出来的只有一条数据。如图
•