![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-56/ti_inject-812ce.png)
检索选修课程"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');