SQL 练习38

  • 查询选修了全部课程的学生信息
SELECT * from Student WHERE SId IN (
	SELECT sid   from sc GROUP BY sid HAVING COUNT(cid) = (SELECT COUNT(*) FROM Course))

image

posted @ 2021-08-21 09:29  弩哥++  阅读(27)  评论(0)  编辑  收藏  举报