sql 合并多条sql语句

1.最近用到将多条数据合并成一行的案例。整理以至于不在忘记。（sql语句如下）

SELECT student_name ,student_no ,SUM(CASE WHEN subject_name='数学' THEN score ELSE '' END) as '数学' ,SUM(CASE WHEN subject_name='语文' THEN score ELSE '' END) as '语文' ,SUM(CASE WHEN subject_name='英语' THEN score ELSE '' END) as '英语' FROM table_test_one GROUP BY student_name,student_no

2.如图效果