SQL面试50题-35
35、查询所有学生的课程及分数情况（重点）
SELECT st.s_name ,MAX(CASE WHEN sc.c_id = '01' THEN sc.s_score ELSE NULL END ) AS "语文" ,MAX(CASE WHEN sc.c_id = '02' THEN sc.s_score ELSE NULL END ) AS "数学" ,MAX(CASE WHEN sc.c_id = '03' THEN sc.s_score ELSE NULL END ) AS "英语" FROM Student st INNER JOIN Score sc ON sc.s_id = st.s_id INNER JOIN Course co ON co.c_id = sc.c_id GROUP BY st.s_name
查看10道真题和解析