查询选修了课程号为“C2”的学生中成绩最高的学生的学号，正确的SELECT语句是（）。
A: SELECTS
B: FROMSC WHEREC
C: ='C2'ANDGRADE>=ALL
D: (SELECTGRADE FROMSC WHEREC
E: ='C2'）
F: SELECTS
G: FROMSC WHEREC
H: ='C2'ANDGRADEIN
I: (SELECTMAX(GRADE) FROMSC WHEREC
J: ='C2'）
K: SELECTS
L: FROMSC WHEREC
M: ='C2'ANDGRADE=
N: (SELECTMAX(GRADE) FROMSC WHEREC
O: ='C2'）
P: SELECTS
Q: FROMSC WHEREC
R: ='C2'ANDGRADE>=ANY
S: (SELECTGRADE FROMSC WHEREC
T: ='C2'）
A: SELECTS
B: FROMSC WHEREC
C: ='C2'ANDGRADE>=ALL
D: (SELECTGRADE FROMSC WHEREC
E: ='C2'）
F: SELECTS
G: FROMSC WHEREC
H: ='C2'ANDGRADEIN
I: (SELECTMAX(GRADE) FROMSC WHEREC
J: ='C2'）
K: SELECTS
L: FROMSC WHEREC
M: ='C2'ANDGRADE=
N: (SELECTMAX(GRADE) FROMSC WHEREC
O: ='C2'）
P: SELECTS
Q: FROMSC WHEREC
R: ='C2'ANDGRADE>=ANY
S: (SELECTGRADE FROMSC WHEREC
T: ='C2'）
举一反三
- 检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是（）。 A: SELECTS B: FORMSCWHEREC C: =“C2”ANDGRADE＞＝(SELECTGRADEFORMSC D: EREC E: =“C2”) F: SELECTS G: FORMSC H: EREC I: =“C2”ANDGRADEIN J: ELECTGRADEFORMSC K: EREC L: =“C2”) M: SELECTS N: FORMSC O: EREC P: =“C2”ANDGRADENOTIN Q: ELECTGRADEFORMSC R: EREC S: =“C2”) T: SELECTS U: FORMSC V: EREC W: =“C2”ANDGRADE＞＝ALL
- 基于教材上的选课表SC，使用嵌套查询查找所有超过所选课程平均分的学生选课记录，正确的SQL语句是________。 A: SELECTSno, Cno, Grade FROMSC SC1WHERE Grade>;(SELECT AVG(Grade) FROMSC SC2); B: SELECTSno, Cno, Grade FROMSC SC1WHERE Grade>;(SELECT AVG(Grade) FROMSC SC2 WHERE SC2.Cno=SC1.Cno); C: SELECTSno, Cno, Grade FROMSC SC1WHERE Grade>;(SELECT AVG(Grade) FROMSC SC2 GROUP BY SC2.Cno); D: SELECTSno, Cno, Grade FROMSC SC1WHERE AVG(Grade)>;(SELECT Grade FROMSC SC2 WHERE SC2.Cno=SC1.Cno);
- 检索选修课程‘C2’的学生中成绩最高的学生的学号。正确的SELECT语句是( )。 A: SELECT S B: FORM SCWHERE C C: =‘C2’ AND GRADE>=(SELECT GRADE FORM SCWHERE C D: =‘C2’) E: SELECT S F: FORM SCWHERE C G: =‘C2’ AND GRADE IN(SELECT GRADE FORM SCWHERE C H: =‘C2’) I: SELECT S J: FORM SCWHERE C K: =‘C2’ AND GRADE NOT IN(SELECT GRADE FORM SCWHERE C L: =‘C2’) M: SELECT S N: FORM SCWHERE C O: =‘C2’ AND GRADE>=ALL(SELECT GRADE FORM SCWHERE C P: =‘C2’)
- 检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是( ). A: SELECT S B: FORM SC WHERE C C: =“C2” AND GRAD>=(SELECT GRADE FORM SCWHERE C D: =“C2”) E: SELECT S F: FORM SCWHERE C G: =“C2” AND GRADE IN(SELECT GRADE FORM SCWHERE C H: =“C2”) I: SELECT S J: FORM SCWHERE C K: =“C2” AND GRADE NOT IN(SELECT GRADE FORM SCWHERE C L: =“C2”) M: SELECT S N: FORM SCWHERE C O: =“C2” AND GRADE>=ALL(SELECT GRADE FORM SCWHERE 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 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’)