把多条成绩单（不同学科，同一个人），合并成一条记录 用case when group by

例子：

SELECT name,SUM(CASE when `subject`='语文' then fenshu end) as '语文',SUM(CASE when `subject`='数学' then fenshu end) as '数学' ,SUM(CASE when `subject`='英语' then fenshu end) as '英语' from chengji  GROUP BY name