select * from student where sno in

(select sno from sc group by sno having count(*)=(select count(*)from course))


通过sc表中sno分组，如果总条数等于课程表总课程，说明已找出选修所有课程的学生no