36）“查詢选修了 3 门以上课程的学生的学生号”，正确的 SQL 语句是 。
(A)SELECT S# FROM SC GROUP BY S# WHERE COUNT *)>3
(B)SELECT S# FROM SC GROUPBY S# HAVING COUNT *)>3
(C)SELECT S# FROM SC ORDERBY S# HAVING COUNT *)>3
(D)SELECT S# FROM SC ORDER BY S# WHERE COUNT *)>3

相關試題

相關試卷