检索选修课程‘C2’的学生中成绩最高的学生的学号。正确的select语句为( )。
A: select S
B: from sc where C
C: =‘C2’and grade>= (select grade from sc where C
D: =‘C2’)
E: select S
F: from sc where C
G: =‘C2’and grade in (select grade from sc where C
H: =‘C2’)
I: select S
J: from sc where C
K: =‘C2’and grade not in (select grade from sc where C
L: =‘C2’)
M: select S
N: from sc where C
O: =‘C2’and grade>=all (select grade from sc where C
P: =‘C2’)
A: select S
B: from sc where C
C: =‘C2’and grade>= (select grade from sc where C
D: =‘C2’)
E: select S
F: from sc where C
G: =‘C2’and grade in (select grade from sc where C
H: =‘C2’)
I: select S
J: from sc where C
K: =‘C2’and grade not in (select grade from sc where C
L: =‘C2’)
M: select S
N: from sc where C
O: =‘C2’and grade>=all (select grade from sc where C
P: =‘C2’)
举一反三
- 检索选修“C2”课程的学生中成绩最高的学生的学号。正确的SELECT语句是( )。 A: SELECT s B: FROM sc WHERE c C: =’C2’ AND grade>=(SELECT grade FROM sc WHERE c D: =’C2’); E: SELECT s F: FROM sc WHERE c G: =’C2’ AND grade IN(SELECT grade FROM sc WHERE c H: =’C2’); I: SELECT s J: FROM sc WHERE c K: =’C2’ AND grade NOT IN(SELECT grade FORM sc WHERE c L: =’C2’); M: SELECT s N: FROM sc WHERE c O: =’C2’ AND grade>=(SELECT max(grade) FROM sc WHERE c P: =’C2’);
- 假设有三个基本表:学生表S、课程表C、学生选课表SC,它们的结构如下:S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE)检索选修课程”C2”的学生中成绩最高的学生的学号。正确的SELECT语句是( )。 A: SELECT S B: FROM SC WHERE C C: =”C2” AND GRADE>=(SELECT GRADE FROM SC WHERE C D: = “C2”) E: SELECT S F: FROM SC WHERE C G: =”C2” AND GRADE IN (SELECT GRADE FROM SC WHERE C H: = “C2”) I: SELECT S J: FROM SC WHERE C K: =”C2” AND GRADE NOT IN (SELECT GRADE FROM SC WHERE C L: = “C2”) M: SELECT S N: FROM SC WHERE C O: =”C2” AND GRADE>=ALL (SELECT GRADE FROM SC WHERE C P: = “C2”)
- 检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是()。 A: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE >= ( SELECT GRADE FORM SC WHERE CNO='C2' ); B: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE IN ( SELECT GRADE FORM SC WHERE CNO='C2' ); C: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE NOT IN ( SELECT GRADE FORM SC WHERE CNO='C2' ); D: SELECT SNO FROM SC WHERE CNO='C2' AND GRADE >= ALL ( SELECT GRADE FORM SC WHERE CNO='C2' );
- 有学生表S(S#,SN,SEX,AGE,DEPT),课程表C(C#,CN),学生选课表SC(S#,C#,GRADE),检索选修课程"C2"的学生中成绩最高的学生的学号,正确的SELECT语句是_________。 A: SELECT S# FROM SCWHERE C#="C2" AND GRADE>=(SELECT GRADE FROM SC WHERE C#="C2") B: SELECT S# FROM SCWHERE C#="C2" AND GRADE IN(SELECT GRADE FROM SC WHERE C#="C2") C: SELECT S# FROM SCWHERE C#="C2" AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#="C2") D: SELECT S# FROM SCWHERE C#="C2" AND GRADE>=ALL
- 检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是( )。 A: SELECT S B: FORM SC WHERE C C: ='C2' AND GRAD>=<br>(SELECT GRADE FORM SC<br>WHERE C D: ='C2') E: SELECT S F: FORM SC<br>WHERE C G: ='C2' AND GRADE IN<br>(SELECT GRADE FORM SC<br>WHERE C H: ='C2') I: SELECT S J: FORM SC<br>WHERE C K: ='C2' AND GRADE NOT IN<br>(SELECT GRADE FORM SC<br>WHERE C L: ='C2') M: SELECT S N: FORM SC<br>WHERE C O: ='C2' AND GRADE>=ALL<br>(SELECT GRADE FORM SC<br>WHERE C P: ='C2')