SELECT st.stuid, st.stunm,
MAX(CASE c.coursenm WHEN ‘大学语文’ THEN s.scores ELSE 0 END ) ‘大学语文’,
MAX(CASE c.coursenm WHEN ‘新视野英语’ THEN IFNULL(s.scores,0) ELSE 0 END ) ‘新视野英语’,
MAX(CASE c.coursenm WHEN ‘离散数学’ THEN IFNULL(s.scores,0) ELSE 0 END ) ‘离散数学’,
MAX(CASE c.coursenm WHEN ‘概率论与数理统计’ THEN IFNULL(s.scores,0) ELSE 0 END ) ‘概率论与数理统计’,
MAX(CASE c.coursenm WHEN ‘线性代数’ THEN IFNULL(s.scores,0) ELSE 0 END ) ‘线性代数’,
MAX(CASE c.coursenm WHEN ‘高等数学(一)’ THEN IFNULL(s.scores,0) ELSE 0 END ) ‘高等数学(一)’,
MAX(CASE c.coursenm WHEN ‘高等数学(二)’ THEN IFNULL(s.scores,0) ELSE 0 END ) ‘高等数学(二)’
FROM student st
LEFT JOIN score s ON st.stuid = s.stuid
LEFT JOIN courses c ON c.courseno = s.courseno
GROUP BY st.stuid
mysql行转列sql
最新推荐文章于 2024-02-01 17:18:00 发布