现有表格student、curriculum、sc表如下
我们想要获取选修了所有课程的学生
sql如下
SELECT
*
FROM
student
WHERE
id IN (
SELECT
student_id
FROM
sc
WHERE
curriculum_id IN ( SELECT id FROM curriculum )
GROUP BY
student_id
HAVING
COUNT( student_id )=(
SELECT
COUNT(*)
FROM
curriculum
));
运行结果如下