- 表如下
- 第一种 case when then
SELECT
s.name
,
SUM( CASE s.subject
WHEN ‘语文’ THEN s.score ELSE 0 END ) AS ‘语文’,
SUM( CASE s.subject
WHEN ‘数学’ THEN s.score ELSE 0 END ) AS ‘数学’,
SUM( CASE s.subject
WHEN ‘英语’ THEN s.score ELSE 0 END ) AS ‘英语’
FROM
score s
GROUP BY
s.NAME
- 第二种if
SELECT s.
name
,
SUM(IF(subject
=‘语文’,score,0)) as ‘语文’,
SUM(IF(subject
=‘数学’,score,0)) as ‘数学’,
SUM(IF(subject
=‘英语’,score,0)) as ‘英语’
FROM score s
GROUP BY s.name
- 查询结果