数据库

<{p}>三个表即学生表S、课程表C和学生选课表SC,它们的结构如下:<{br/}>S(S#,SN,SEX,AGE,DEPT)<{br/}>C(C#,CN)<{br/}>SC(S#,C#,GRADE)<{br/}>其中:S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程号,CN为课程名,GRADE为成绩。<{br/}>检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是( )。<{/p}>

发布于 2021-02-18 21:07:21

【单选题】
A <{p}>SELECT S# FORM SC<{br/}>WHERE C#=“C2” AND GRADE NOT IN<{br/}>(SELECT GRADE FORM SC<{br/}>WHERE C#=“C2”)<{/p}>
B <{p}>SELECT S# FORM SC<{br/}>WHERE C#=“C2” AND GRADE>=ALL<{br/}>(SELECT GRADE FORM SC<{br/}>WHERE C#=“C2”)<{/p}>
C <{p}>SELECT S# FORM SC<{br/}>WHERE C#=“C2” AND GRAD>=<{br/}>(SELECT GRADE FORM SC<{br/}>WHERE C#=“C2”)<{/p}>
D <{p}>SELECT S# FORM SC<{br/}>WHERE C#=“C2” AND GRADE IN<{br/}>(SELECT GRADE FORM SC<{br/}>WHERE C#=“C2”)<{/p}>

关注者

被浏览

撰写答案

关于作者

阿晴

相关问题