-- 45、查询选修了全部课程的学生信息

科技2025-04-03 20

SELECT st.* FROM student st LEFT JOIN score sc ON sc.s_id=st.s_id GROUP BY st.s_id HAVING COUNT(1)=(SELECT COUNT(1) FROM course)

Processed: 0.012, SQL: 8