题目
若要求“查询选修了3门以上课程的学生的学生号”,正确的SQL语句是( )。
A.SELECT S# FROM SC GROUP BY S# WHERE COUNT(*)>3B.SELECT S# FROM SC GROUP BY S# HAVING COUNT(*)>3C.SELECT S# FROM SC ORDER BY S# WHERE COUNT(*)>3D.SELECT S# FROM SC ORDER BY S# HAVING COUNT(*)>3
提示:未搜索到的试题可在搜索页快速提交,您可在会员中心"提交的题"快速查看答案。
答案
查看答案
搜题