![](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 S 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')