答案窝,daanwo.com

[单选题]"设有三个表,即学生表S,课程表C,学生选课表SC。它们的结构如下: S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE) 检索选修课程“C2”的学生中成绩最高的学生的学号()T1h答案窝(daanwo.com)-大学生作业答案及考资分享平台
Aselect s# from sc where c#=”C2” and grade>=(select grade from sc where c#=”C2”) ;T1h答案窝(daanwo.com)-大学生作业答案及考资分享平台
Bselect s# from sc where c#=”C2” and grade in (select grade from sc where c#=”C2”) ;T1h答案窝(daanwo.com)-大学生作业答案及考资分享平台
Cselect s# from sc where c#=”C2” and grade not in (select grade from sc where c#=”C2”) ;T1h答案窝(daanwo.com)-大学生作业答案及考资分享平台
Dselect s# from sc where c#=”C2” and grade >=all (select grade from sc where c#=”C2”) ;

答案窝,daanwo.com