怎么查询选修了所有课程的学生呢???
课程是一个表 ,选课情况是一个表,,学生情况是一个表
SELECT Student.Sname, Student.Sdept,
FROM Student INNER JOIN (Course INNER JOIN SC ON Course.Cno = SC.Cno) ON Student.Sno = SC.Sno
课程是一个表 ,选课情况是一个表,,学生情况是一个表
SELECT Student.Sname, Student.Sdept,
FROM Student INNER JOIN (Course INNER JOIN SC ON Course.Cno = SC.Cno) ON Student.Sno = SC.Sno
INNER JOIN SC as b on a.Sno = b.Sno GROUP BY a.Sname Having count(a.Sname) = (select count(*) from Course)
INNER JOIN SC as b on a.Sno = b.Sno GROUP BY a.Sname Having count(a.Sname) = (select sum(1) from Course)