准备一张学生成绩表test_1
![](https://i-blog.csdnimg.cn/blog_migrate/b944ccf4f0ae1bc6f6f4afcbb057cf6e.png)
执行sql
select name '姓名',
sum(case when course ='英语' THEN core Else '0' End) '英语',
sum(case when course ='语文' THEN core Else '0' End) '语文',
sum(case when course ='数学' THEN core Else '0' End) '数学'
from test_1 group by name;
得到结果表
![](https://i-blog.csdnimg.cn/blog_migrate/2a12c006f95654d06871ca46c957db1e.png)