問題詳情

36)若要求“查詢选修了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

參考答案

答案:C
難度:適中0.5
統計:A(0),B(0),C(0),D(0),E(0)

內容推薦

內容推薦