已知选课关系SC(S# char(8), C# char(8), GRADE integer),S#,C#课程号,GRADE成绩。检索选修课程'C2'的学生中成绩最高的学生的。正确的SELECT语句是()。
A.
SELECT S# FROM SC WHERE C#= 'C2' AND GRADE >=( SELECT GRADE FROM SC WHERE C#= 'C2' )
B.
SELECT S# FROM SC WHERE C#= 'C2' AND GRADE IN ( SELECT GRADE FROM SC WHERE C#= 'C2' )
C.
SELECT S# FROM SC WHERE C#= 'C2' AND GRADE >= ALL ( SELECT GRADE FROM SC WHERE C#= 'C2' )
D.
SELECT S# FROM SC WHERE C#= 'C2' AND GRADE NOT IN ( SELECT GRADE FROM SC WHERE C#= 'C2' )