检索选修课程 "C2"的学生中成绩最高的学生的学号。正确的SeLECT 的语句是
A.SELECT S# FORM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) WHERE C#="C2")
B.SELECT S#FORM SC WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) WHERE C#="C2"
C.SELECT S# FORM SC WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC WHERE C#="C2")
D.SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")
查看答案
正确答案: C 答案分析:无
包含此试题的试卷:
相关的试题
A.SELECT S# FORM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) WHERE C#="C2")
B.SELECT S#FORM SC WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) WHERE C#="C2"
C.SELECT S# FORM SC WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC WHERE C#="C2")
D.SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")
A.SELECT S# FORM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) WHERE C#="C2")
B.SELECT S#FORM SC WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) WHERE C#="C2"
C.SELECT S# FORM SC WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC WHERE C#="C2")
D.SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")
A.SELECT S# FORM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) WHERE C#="C2")
B.SELECT S#FORM SC WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) WHERE C#="C2"
C.SELECT S# FORM SC WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC WHERE C#="C2")
D.SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")
A.SELECT S# FORM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) WHERE C#="C2")
B.SELECT S#FORM SC WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) WHERE C#="C2"
C.SELECT S# FORM SC WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC WHERE C#="C2")
D.SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")
A.SELECT S# FORM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) WHERE C#="C2")
B.SELECT S#FORM SC WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) WHERE C#="C2"
C.SELECT S# FORM SC WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC WHERE C#="C2")
D.SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")
A.SELECT S# FORM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) WHERE C#="C2")
B.SELECT S#FORM SC WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) WHERE C#="C2"
C.SELECT S# FORM SC WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC WHERE C#="C2")
D.SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")
A.SELECT S# FORM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) WHERE C#="C2")
B.SELECT S#FORM SC WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) WHERE C#="C2"
C.SELECT S# FORM SC WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC WHERE C#="C2")
D.SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")
A.SELECT S# FORM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) WHERE C#="C2")
B.SELECT S#FORM SC WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) WHERE C#="C2"
C.SELECT S# FORM SC WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC WHERE C#="C2")
D.SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")
A.SELECT S# FORM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) WHERE C#="C2")
B.SELECT S#FORM SC WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) WHERE C#="C2"
C.SELECT S# FORM SC WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC WHERE C#="C2")
D.SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")
A.SELECT S# FORM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) WHERE C#="C2")
B.SELECT S#FORM SC WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) WHERE C#="C2"
C.SELECT S# FORM SC WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC WHERE C#="C2")
D.SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")