查询选课门数等于课程总数的学生学号

Question

查询选课门数等于课程总数的学生学号，student（sno，sname，ssex，sage，sdept）
course（cno，cname，cpno，ccredit）
sc（sno，cno，grade）

Answer 1

select sno from(select sno,count(sno) as num from sc
group by sno
having count(sno)=(select count(cno) from course))tb

查询学生的所有信息用下面的

select * from student where sno in( select sno from(select sno,count(sno) as num from sc
group by sno
having count(sno)=(select count(cno) from course))tb)