数据源:
SELECT
stu_id
FROM
stu_course
WHERE
stu_id NOT IN ( SELECT stu_id FROM stu_course WHERE course_id NOT IN ( SELECT course_id FROM stu_course WHERE stu_id = 1001 ) )
GROUP BY
stu_id
HAVING
count( * ) = ( SELECT count( * ) FROM stu_course WHERE stu_id = 1001 );
结果: