有学生表S(S#,SN,SEX,AGE,DEPT),课程表C(C#,CN),学生选课表SC(S#,C#,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 IN(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>=ALL