2. 科技
    3. 查询所有课程的成绩第2名到第3名的学生信息及该课程成绩

    查询所有课程的成绩第2名到第3名的学生信息及该课程成绩

    科技2024-01-09  71

    建表语句点击详见

    – 查询所有课程的成绩第2名到第3名的学生信息及该课程成绩

    (SELECT st.*,sc.s_score FROM score sc,student st WHERE sc.s_id = st.s_id AND sc.c_id = '01' ORDER BY sc.s_score DESC LIMIT 1,2) UNION ALL (SELECT st.*,sc.s_score FROM score sc,student st WHERE sc.s_id = st.s_id AND sc.c_id = '02' ORDER BY sc.s_score DESC LIMIT 1,2) UNION ALL (SELECT st.*,sc.s_score FROM score sc,student st WHERE sc.s_id = st.s_id AND sc.c_id = '03' ORDER BY sc.s_score DESC LIMIT 1,2)
    Processed: 0.019, SQL: 8