检索选修课程'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. SC) 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')