问题
单项选择题
“查询选修了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#HAVING COUNT(*)>3
D．SELECT S#FROM SC ORDER BY S#WHERE COUNT(*)>3
答案
参考答案：B