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
举一反三
- 查询选修了课程号为“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')
- 检索选修课程‘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’)
- 检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是( ) A: A.SELECT S B: FORM SC WHERE C C: =“C2” AND GRAD>= (SELECT GRADE FORM SC WHERE C D: =“C2”) E: B.SELECT S F: FORM SC WHERE C G: =“C2” AND GRADE IN (SELECT GRADE FORM SC WHERE C H: =“C2”) I: C.SELECT S J: FORM SC WHERE C K: =“C2” AND GRADE NOT IN (SELECT GRADE FORM SC WHERE C L: =“C2”) M: D.SELECT S N: FORM SC WHERE C O: =“C2” AND GRADE>=ALL (SELECT GRADE FORM SC WHERE C P: =“C2”)
内容
- 0
检索选修“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’);
- 1
检索选修课程“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')
- 2
假设有三个基本表:学生表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”)
- 3
检索选修课程"C2"的学生中成绩最高的学生的学号。正确的SELECT的语句是______。 A: SELECT S# FORM SC B: WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) C: WHERE C#="C2") D: SELECT S#FORM SC E: WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) F: WHERE C#="C2" G: SELECT S# FORM SC H: WHERE C#="C2" AND GRADE NOT IN(SELECT GRADE FORM SC I: WHERE C#="C2" J: SELECT S# FORM SC K: WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC L: WHERE C#="C2")
- 4
学生表S、课程表C和学生选课表SC,它们的结构如下: S(S#,SN,SEX,AGE,DEPT)C(C#,CN)SC(S#,C#,GRADE) 其中,S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程号,CN为课程名,GRADE为成绩。查询选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是 A: SELECT S B: FROM SCWHERE C C: =“C2” AND GRADE >= (SELECT GRADE FROM SCWHERE C D: =“C2”) E: SELECT S F: FROM SCWHERE C G: =“C2” AND GRADE IN (SELECT MAX(GRADE) FROM SCWHERE C H: =“C2”) I: SELECT S J: FROM SCWHERE C K: =“C2” AND GRADE IN (SELECT GRADE FROM SCWHERE C L: =“C2”) M: SELECT S N: FROM SCWHERE C O: =“C2” AND GRADE > ALL (SELECT GRADE FROM SCWHERE C P: =“C2”)