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”)
举一反三
- 有学生表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
- 题中假定学生关系是S(S#,SN.,SEX,AGE)，课程关系是C(C#,CNAME,TEACH-ER)，学生选课关系是SC(S#,C#,GRADE)。 检索选修课程"C2”的学生中成绩最高的学生的学号，正确的SELECT语句是______。 A: SELECT S# FORM SCWHERE C#="C2"AND GRADE＞=(SELECT GRADE FORM SCWHERE C#="C2") B: SELECT S# FORM SCWHERE C#="C2"AND GRADE IN(SELECT GRADE FORM SC.WHERE C#="C2" C: SELECT S# FORM SCWHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SCWHERE C#="C2") D: SELECT S# FORM SCWHERE C#="C2"AND GRADE＞=ALL(SELECT GRADE FORM SCWHERE C#="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 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: 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’)
内容
- 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 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’)
- 1
三个表学生表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: ELECT S# FORM SC WHERE C#=’C2’ AND GRAD>=(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’)
- 2
检索选修“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’);
- 3
以下题目基于这样的3个表即学生表S、课程表C和学生选课表SC，它们的结构如下： S(S#，SN，SEX，AGE，DEPT) C(C#，CN) SC(S#，C#，GRADE) 其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，DEPT为系别，C#为课程号，CN为课程名，GRADE为成绩。检索选修课程“高级程序设计”的男生中的最高成绩，正确的SELECT语句是（ ） A: SELECT MAX(GRADE) FROM SC，C，SWHERE SC.C B: =C C: AND SS D: =S E: AND CN='高级程序设计' AND SEX='男' F: SELECT MAX(GRADE) FROM SC，CWHERE CN=‘高级程序设计’ AND SEX=‘男’ G: SELECTMAX(GRADE) FROM SC，C，SWHERE CN=‘高级程序设计’ AND SEX=‘男’ H: SELECTMAX(GRADE) FROM SCWHERE CN='高级程序设计’AND SEX='男'
- 4
3个表即学生表S、课程表C和学生选课表SC，它们的结构如下： S(S#，SN，SEX，AGE，DEPT)C(C#，CN)SC(S#，C#，GRADE)其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，DEPT为系别，C#为课程号，CN为课程名，GRADE为成绩。检索选修课程名称为“DB”的男生中的最高成绩，正确的SELECT语句是____。 A: SELECT MAX(GRADE) FROM SC WHERE CN='DB’ AND SEX='男' B: SELECT MAX(GRADE) FROM SC，C，SWHERE CN='DB' AND SEX='男' C: SELECT MAX(GRADE) FROM SC，S WHERE SC D: =C E: AND CN='DB' AND SEX='男' F: SELECT MAX(GRADE) FROM SC，C，SWHERE SC G: =C H: AND SS I: =S.S J: AND CN='DB' AND SEX='男'