sql笔试题（2）

查询选修了超过4门课功课的学生的学号和姓名

方法一：

SELECT student.sNo,student.sName
FROM student_table student
WHERE student.sNo
IN (
SELECT sc.sNo
FROM sc_table sc
GROUP BY sc.sNo,sc.cNo
HAVING COUNT(*)>=4)

 

方法二：

SELECT student.sNo,student.sName
FROM student_table student
WHERE (SELECT COUNT(*)
FROM sc_table sc
WHERE sc.sNo=student.sNo)>=1