SQL 练习38
- 查询选修了全部课程的学生信息
SELECT * from Student WHERE SId IN (
SELECT sid from sc GROUP BY sid HAVING COUNT(cid) = (SELECT COUNT(*) FROM Course))
原文:https://www.cnblogs.com/bangbangzoutianya/p/15168869.html
SELECT * from Student WHERE SId IN (
SELECT sid from sc GROUP BY sid HAVING COUNT(cid) = (SELECT COUNT(*) FROM Course))
原文:https://www.cnblogs.com/bangbangzoutianya/p/15168869.html