注意:此页面搜索的是所有试题
要查询选修了3门以上课程的学生的学号,则正确的SQL语句是:
SELECT 学号 FROM 选课( )。
A
GROUP BY 学号 WHERE COUNT(*)>3
B
GROUP BY 学号 HAVING COUNT(*)>3
C
ORDER BY 学号 WHERE COUNT(*)>3
D
ORDER BY 学号 HAVING COUNT(*)>3
SELECT 学号 FROM 选课( )。
A
GROUP BY 学号 WHERE COUNT(*)>3
B
GROUP BY 学号 HAVING COUNT(*)>3
C
ORDER BY 学号 WHERE COUNT(*)>3
D
ORDER BY 学号 HAVING COUNT(*)>3
参考答案