检索选修课程"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 GRADE FORM. SC) WHERE C#="C2"C．SELECT S# FORM. SC WHERE C#="C2"AND GRADE NO
题目
检索选修课程"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 GRADE FORM. SC) WHERE C#="C2"
C．SELECT S# FORM. SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM. SC WHERE C#="C2")
D．SELECT S# FORM. SC WHERE C#="C2"AND GRADE＞=ALL(SELECT GRADE FORM. SC WHERE C#="C2")
相似考题
更多“检索选修课程"C2”的学生中成绩最高的学生的学号,正确的SELECT语句是______。A.SELECT S# FORM. SC ”相关问题
-
第1题：
10、已知选课关系SC（S# char（8), C# char（8), GRADE integer)，S#学号，C#课程号，GRADE成绩。检索选修课程'C2'的学生中成绩最高的学生的学号。正确的SELECT语句是_________。
A．SELECT S# FROM SC WHERE C#='C2' AND GRADE ＞= ALL(SELECT GRADE FROM SC WHERE C#='C2')
B．SELECT S# FROM SC WHERE C#='C2' AND GRADE ＞=(SELECT GRADE FROM SC WHERE C#='C2')
C．SELECT S# FROM SC WHERE C#='C2' AND GRADE IN (SELECT GRADE FROM SC WHERE C#='C2')
D．SELECT S# FROM SC WHERE C#='C2' AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#='C2')
A -
第2题：
已知选课关系SC（S# char（8), C# char（8), GRADE integer)，S#学号,C#课程号,GRADE成绩。检索选修课程'C2'的学生中成绩最高的学生的学号。正确的SELECT语句是（）。
A．SELECT S# FROM SC WHERE C#='C2' AND GRADE ＞=MAX(SELECT GRADE FROM SCWHERE C#='C2');
B．SELECT S# FROM SC WHERE C#='C2' AND GRADE ＞= ALL(SELECT GRADE FROM SC WHERE C#='C2');
C．SELECT S# FROM SC WHERE C#='C2' AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#='C2');
D．SELECT S# FROM SC WHERE C#='C2' AND GRADE IN (SELECT GRADE FROM SCWHERE C#='C2');
A -
第3题：
基于这样的3个表，即学生表S、课程表C和学生选课表SC，它们的关系模式如下： S（S#，SN，SEX，AGE，DEPT)（学号，姓名，性别，年龄，系别) C（C#，CN)（课程号，课程名称) SC（S#，C#，GRADE)（学号，课程号，成绩) 检索选修课程“C2”的学生中成绩最低的学生的学号。正确的SELECT语句是（）。
A．SELECT S# FROM SC WHERE C#='C2' AND GRADE＜=(SELECT GRADE FROM SC WHERE C#='C2')
B．SELECT S# FROM SC WHERE C#='C2' AND GRADE IN(SELECT GRADE FROM SC WHERE C#='C2')
C．SELECT S# FROM SC WHERE C#='C2' AND GRADE NOT IN (SELECT GRADE GORM SC WHERE C#='C2')
D．SELECT S# FROM SC WHERE C#='C2' AND GRADE＜=ALL(SELECT GRADE FROM SC WHERE C#='C2')
SELECT S.SN,SC.C#,SC.GRADE FROM S, SC WHERE S.S#=SC.S# -
第4题：
77、已知选课关系SC（S# char（8), C# char（8), GRADE integer)，S#学号，C#课程号，GRADE成绩。检索选修课程'C2'的学生中成绩最高的学生的学号。正确的SELECT语句是_________。
A．SELECT S# FROM SC WHERE C#='C2' AND GRADE ＞= ALL(SELECT GRADE FROM SC WHERE C#='C2')
B．SELECT S# FROM SC WHERE C#='C2' AND GRADE ＞=(SELECT GRADE FROM SC WHERE C#='C2')
C．SELECT S# FROM SC WHERE C#='C2' AND GRADE IN (SELECT GRADE FROM SC WHERE C#='C2')
D．SELECT S# FROM SC WHERE C#='C2' AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#='C2')
A -
第5题：
基于这样的3个表，即学生表S、课程表C和学生选课表SC，它们的关系模式如下：S（S#，SN，SEX，AGE，DEPT)（学号，姓名，性别，年龄，系别)C（C#，CN)（课程号，课程名称)SC（S#，C#，GRADE)（学号，课程号，成绩).检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是（)。
A．SELECT S# FROM SC WHERE C#=C2 AND GRADE＞=(SELECT GRADE FROM SC WHERE C#=C2)
B．SELECT S# FROM SC WHERE C#=C2 AND GRADE IN(SELECT GRADE FROM SC WHERE C#=C2)
C．SELECT S# FROM SC WHERE C#=C2 AND GRADE NOT IN (SELECT GRADE GORM SC WHERE C#=C2)
D．SELECT S# FROM SC WHERE C#=C2 AND GRADE＞=ALL(SELECT GRADE FROM SC WHERE C#=C2)
SELECT S# FROM SC WHERE C#=’C2’ AND GRADE＞=ALL(SELCET GRADE FROM SC WHERE C#=’C2’) -
第6题：
已知选课关系SC（S# char（8), C# char（8), GRADE integer)，S#学号，C#课程号，GRADE成绩。检索选修课程'C2'的学生中成绩最高的学生的学号。正确的SELECT语句是_________。
A．SELECT S# FROM SC WHERE C#='C2' AND GRADE IN (SELECT GRADE FROM SC WHERE C#='C2')
B．SELECT S# FROM SC WHERE C#='C2' AND GRADE ＞= ALL(SELECT GRADE FROM SC WHERE C#='C2')
C．SELECT S# FROM SC WHERE C#='C2' AND GRADE ＞=(SELECT GRADE FROM SC WHERE C#='C2')
D．SELECT S# FROM SC WHERE C#='C2' AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#='C2')
A