注意:此页面搜索的是所有试题
题目内容
(国家开放大学数据库应用技术)
查询语句中,错误的是( )。
单选题 (3 分) 3分
A.
SELECT Sno, COUNT(*) FROM SC GROUP BY Sno
B.
SELECT Sno FROM SC GROUP BY Sno WHERE COUNT(*) > 3
C.
SELECT Sno FROM SC GROUP BY Sno HAVING COUNT(*) > 3
D.
SELECT Sno FROM SC GROUP BY Sno
单选题 (3 分) 3分
A.
SELECT Sno, COUNT(*) FROM SC GROUP BY Sno
B.
SELECT Sno FROM SC GROUP BY Sno WHERE COUNT(*) > 3
C.
SELECT Sno FROM SC GROUP BY Sno HAVING COUNT(*) > 3
D.
SELECT Sno FROM SC GROUP BY Sno
参考答案