SELECT A.`name`,
MAX( CASE A.course WHEN 'Chinese' THEN A.score ELSE 0 END ) Chinese,
MAX( CASE A.course WHEN 'Math' THEN A.score ELSE 0 END ) Math
FROM
`user` as A
WHERE 1=1 GROUP BY A.`name`
原始数据:
查询结果:
SELECT A.`name`,
MAX( CASE A.course WHEN 'Chinese' THEN A.score ELSE 0 END ) Chinese,
MAX( CASE A.course WHEN 'Math' THEN A.score ELSE 0 END ) Math
FROM
`user` as A
WHERE 1=1 GROUP BY A.`name`
原始数据:
查询结果: