CNO中有关快速查询的说法正确的是()
A.只能查一个指标
B.可以查多个对象
C.只能查KPI指标
D.只能查计数器指标
- · 有3位网友选择 D,占比37.5%
- · 有3位网友选择 C,占比37.5%
- · 有2位网友选择 A,占比25%
A.只能查一个指标
B.可以查多个对象
C.只能查KPI指标
D.只能查计数器指标
A.模糊时间中最近一天是指机器时间的最近一天
B.时间条件中的汇总指在时间上做汇总计算,即每一个查询对象只有一条查询结果
C.指标查询可以查看切换小区对间的指标
D.指标查询可以查看小区组和小区组明细
关系模式SCS(Sno,Cno,Score)中,Sno是学生学号,Cno是课程号,Score是成绩。若要查询每门课成绩的平均成绩,且要求查询结果按平均成绩升序排列,平均成绩相同时,按课程号降序排列,可用SQL语言写为(33)。若查询结果仅限于平均分数超过85分的,则应(34)。
(51)
A.SELECT Cno,AVG(Score)FROM SCS GROUP BY Score ORDER BY 2.Cno DESC
B.SELECT Cno,AVG(Score) FROM SCS GROUP BY Cno ORDER BY 2.Cno DESC
C.SELECT Cno,AVG(Score) FROM SCS ORDER BY Cno DESC ORDER BY Score
D.SELECT Cno,AVG(Score) FROM SCS GROUP BY AVG(Score)ORDER BY Cno DESC
在关系SC中,查询学习课程号为′DB′,且成绩在60至90之间的学生学号的正确的 SQL命令是
A.SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE DETWEEN 60 AND 90
B.SELECT SNO FROM SC WHERE CNO=′DB′OR GRADE BETWEEN 60 AND 90
C.SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE>=60 AND 90
D.SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE<=60 AND GRADE>=90
在关系SC中,查询学习课程号为'OB',且成绩在60至90之间的学生学号的正确的 SQL命令是
A.SELECT SNO FROMSC WHERE CNO='DB' AND GRADE BETWEEN 60 AND 90
B.SELECT SNO FROM SC WHERE CNO='DB' OR GRADE BETWEEN 60 AND 90
C.SELECT SNO FROM SC WHERE CNO='DB' AND GRADE>=60 AND 90
D.SELECTSNO FROM SCWHERECNO='DB' AND GRADE<=60 AND GRADE>=90
A、select sno,cno from sc cno=‘2’
B、select sno cno from sc having cno=‘2’
C、select sno 学号,cno 课程号 from sc having cno=‘2’
D、select sno,cno from sc where cno=‘2’
A、select sno from sc
B、select sno from sc where cno=’1’ or cno=’2’ or cno=’3’
C、select distinct sno,’学号’ from sc
D、select sno from sc where cno<>null
A.SELECT SNO FROM SC WHERE CNO='DB'AND GRADE BETWEEN 60 AND 90
B.SELECT SNO FROM SC WHERE CN0='DB' 0R GRADE BETWEEN 60 AND 90
C.SELECT SNO FROM SC WHERE CNO='DB'AND GRADE>=60 AND 90
D.SELECT SNO FROM SC WHERE CNO='DB'AND GRADE<=60 AND GRADE>=90
在“学生—选课—课程”数据库中的两个关系如下:
S(SNO,SNAME,SEX,AGE) ,SC(SNO,CNO,GRADE)
若使用连接查询的SQL语句查找年龄大于20岁的学生姓名(SNAME) 和成绩 (GRADE) ,则正确的命令是SELECT sname,grade FROM s,sc WHERE age>20 AND ______。
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!