题目：已知选课关系SC(S# char(8), C# char(8), GRADE int)，S#学号,C#课程号,GRADE成绩。检索选修课程'C2'的学生中成绩最高的学生的学号。正确的SELECT语句是（ ）。
A. SELECT S# FROM SC WHERE C#='C2' AND GRADE >=MAX(SELECT GRADE FROM SCWHERE C#='C2');
B. SELECT S# FROM SC WHERE C#='C2' AND GRADE NOT 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 IN (SELECT GRADE FROM SCWHERE C#='C2');
答案：评论后可见此内容
