若要求“查询选修了3门以上课程的学生的学生号”,正确的SQL语句是_______。A
题型:单项选择题
问题:
若要求“查询选修了3门以上课程的学生的学生号”,正确的SQL语句是_______。
A.SELECT S# FROM SC GROUP BY S# WHERE COUNT(*)>3
B.SELECT S# FROM SC GROUP BY S# HAVING COUNT(*)>3
C.SELECT S# FROM SC ORDER BY S# WHERE COUNT(*)>3
D.SELECT S# FROM SC ORDER BY S# HAVING COUNT(*)>3