SELECT st.s_id FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
GROUP BY st.s_id HAVING COUNT(1)>=2
-- 44、检索至少选修两门课程的学生学号
最新推荐文章于 2023-03-25 22:55:02 发布
SELECT st.s_id FROM student st
LEFT JOIN score sc ON sc.s_id=st.s_id
GROUP BY st.s_id HAVING COUNT(1)>=2