目录
没转之前
转换之后
代码
利用case。。。when。。。then进行行转列
SELECT sname,
SUM(CASE `course` WHEN '语文' THEN score ELSE 0 END) as '语文',
SUM(CASE `course` WHEN '数学' THEN score ELSE 0 END) as '数学',
SUM(CASE `course` WHEN '英语' THEN score ELSE 0 END) as '英语'
FROM score
GROUP BY sname
利用if()进行行转列
select sname,
sum(if( `course`='语文',score,0))as'语文',
sum(if( `course`='数学',score,0))as'数学',
sum(if (`course`='英语',score,0))as'英语'
from score
group by sname