一起答
单选

若要求“查询选修了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
参考答案
查看试卷详情