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