【单选题】

检索选修课程 "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 CRADE FORM SC) WHERE C#="C2"
C. SELECT S# FORM SC WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC WHERE C#="C2")
D. SELECT S# FORM SC WHERE C#="C2"AND GRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")