有 这样三个表:学生表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# FROM SC WHERE C#="C2" AND GRADE>=(SELECT GRADE FROM SC WHERE C#="C2")
B、SELECT S# FROM SC WHERE C#="C2" AND GRADE>(SELECT GRADE FROM SC WHERE C#="C2")
C、SELECT S# FROM SC WHERE C#="C2" AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#="C2")
D、SELECT S# FROM SC WHERE C#="C2" AND GRADE=(SELECT MAX(GRADE)FROM SC WHERE C#="C2")