若要求“查询选修了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
若要求“查询选修了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
VIP截止日期:2025-01-02 03:12:18
←请使用支付宝扫码支付VIP截止日期:2025-01-02 03:12:18
←请使用微信扫码支付