查询选修了全部课程的学生信息

叫我影帝梁家辉

SELECT
        student.sid,
        student.sname,
        count( sc.cid ) cnt
FROM
        student
        INNER JOIN sc ON sc.sid = student.sid
GROUP BY
        sc.sid
HAVING
        cnt = (SELECT count( cid ) FROM course)