SELECT `Name` AS 姓名, SUM( CASE `Subject` WHEN '语文' THEN `Result` ELSE 0 END ) AS '语文', SUM( CASE `Subject` WHEN '数学' THEN `Result` ELSE 0 END ) AS '数学', SUM( CASE `Subject` WHEN '物理' THEN `Result` ELSE 0 END ) AS '物理' FROM students GROUP BY NAME
SELECT `姓名` AS 'Name', `语文` AS 'Subject', `语文` AS 'Result' FROM students_1 UNION SELECT `姓名` AS 'Name', `数学` AS 'Subject', `数学` AS 'Result' FROM students_1 UNION SELECT `姓名` AS 'Name', `物理` AS 'Subject', `物理` AS 'Result' FROM students_1 ORDER BY `Name` DESC