问题详情

答题翼 > 问答 > 计算机类考试 > 正文
目录: 标题| 题干| 答案| 搜索| 相关

若要求“查询选修了3门以上课程的学生的学生号”,正确的SQL语句是()。A.SELECT S# FROM SC GROUP B


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

参考答案
您可能感兴趣的试题