检索选修课程"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")