检索选修课程"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# FROM SC WHERE C# ='C2' AND GRADE > = ALL (SELECT GRADE FROM SC WHERE C# ='C2');