SQL行转列的方法

最新推荐文章于 2024-09-09 20:25:50 发布

景韦

最新推荐文章于 2024-09-09 20:25:50 发布

阅读量1k

点赞数

分类专栏：数据库

数据库专栏收录该内容

7 篇文章 0 订阅

订阅专栏

SQL行转列的方法（暂且行转列项目固定）

SELECT DISTINCT  a.name,
(SELECT score FROM grade b WHERE a.name=b.name AND b.course='语文' ) AS '语文',
(SELECT score FROM grade b WHERE a.name=b.name AND b.course='数学' ) AS '数学',
(SELECT score FROM grade b WHERE a.name=b.name AND b.course='英语' ) AS '英语'
FROM grade a

SELECT name,
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 grade GROUP BY name

项目不固定等有空再弄了