检索选修课程"C2”的学生中成绩最高的学生的学号,正确的SELECT语句是( )。
A.
SELECT S# FORM SC WHERE C#='C2' AND GRADE>=(SELECT GRADE FORM SC WHERE C#='C2')
B.
SELECT S# FORM SC WHERE C#='C2' AND GRADE IN(SELECT GRADE FORM S 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')