转载地址:https://www.cnblogs.com/thomas12112406/p/5813394.html
数据表:
列转行:利用max(case when then)
`max``---聚合函数 取最大值`
`(`casecourse when
'语文'
then
score else
0 end
)
---判断`
` as 语文``---别名作为列名`
SELECT `name`,
MAX( CASE WHEN course='语文' THEN score END ) AS 语文,
MAX( CASE WHEN course='数学' THEN score END ) AS 数学,
MAX( CASE WHEN course='英语' THEN score END ) AS 英语
FROM student GROUP BY `name`;