SQL面试50题-38
38、查询课程编号为03且课程成绩在80分以上的学生的学号和姓名(不重要)
SELECT st.s_id,st.s_name FROM Student st INNER JOIN Score sc ON sc.s_id = st.s_id WHERE sc.s_score > 80 AND sc.c_id = '03'
38、查询课程编号为03且课程成绩在80分以上的学生的学号和姓名(不重要)
SELECT st.s_id,st.s_name FROM Student st INNER JOIN Score sc ON sc.s_id = st.s_id WHERE sc.s_score > 80 AND sc.c_id = '03'
相关推荐