赞题库-背景图

单项选择题

在SQL中，集合成员算术比较操作“元组＜＞ALL(集合)”中的“＜＞ALL”的等价操作符是 ______。

A．NOT IN
B．IN
C．＜＞SOME
D．=SOME

<上一题目录下一题>

热门试题

单项选择题检索选修四门以上课程的学生总成绩(不统计不及格的课程)，并要求按总成绩降序排列出来，正确的SELECT语句是______。

A．SELECT S#,SUM(GRADE)FROM SC WHERE GRADE＞=60 CROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)＞=4
B．SELECT S#,SUM(GRADE)FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞=4 ORDER BY 2 DESC
C．SELECT S#,SUM(GRADE)FROM SC WHERE GRADE＞=60 HAVING COUNT(*)＞=4 GROUP BY S# ORDER BY 2 DESC
D．DELECT S#,SUM(GRADＥ)FROM SC WHERE GRADE＞=60 ORDER BY 2 DESC CROUP BY S# HAVING COUNT(*)＞=4

单项选择题检索学生姓名及其所选修课程的课程号和成绩，正确的SELECT语句是______。

A．SELECT S.SN,SC.C#,SC.GRADE FROMS WHERE S.S#=SC.S#
B．SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S.S#=SC.GRADE
C．SELECT S.SN,SC.C#,SC,GRADE FROM S,SC WHERE S.S#：SC.S#
D．SELSECT S.SN,SC.C#,SC.GRADE FROM S,SC