以下哪个方法不属于标准查询运算符?()
A: A.Count()
B: B.Add()
C: C.Where()
D: D.Select()
A: A.Count()
B: B.Add()
C: C.Where()
D: D.Select()
举一反三
- 查询选修了数学课(课程号为2)的学生人数,可以使用的查询语句是: 。 A: SELECT MAX(*) FROM SC WHERE Cno = 2; B: SELECT AVG(Sno) FROM SC WHERE Cno = 2; C: SELECT COUNT(*) FROM SC WHERE Cno = 2; D: SELECT COUNT(Sname) FROM SC WHERE Cno = 2;
- 查询选修了2门课程以上的学生学号() A: select sid,count(*) from sc group by sid having count(*)>=2 B: select sid,count(*) from sc group by sid where count(*)>=2 C: select sid,count(*) from sc where count(*)>=2 group by sid D: select sid,count(*) from sc group by cid having count(*)>=2
- 标准SQL基本查询模块的结构是______。 A: SELECT…FROM…ORDER BY B: SELECT…1WHERE…GROUP BY C: SELECT…WHERE…HAVING D: SELECT…FROM…WHERE
- SQL查询命令的结构是SELECT…FROM…WHERE… GROUP BY…HAVING…ORDER BY…,其中指定查询条件的短语是 A.SELECT B.FROM C.WHERE D.ORDER BY
- SQL的标准函数COUNT,SUM,AVG,MAX,MIN等,不允许出现在查询语句的()子句中。 A: SELECT B: HAVING C: WHERE D: GROUPBY HAVING