检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT的语句是______。A.SELECT S# FROM S
检索选修课程“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 NOT IN(SELECT GRADE FROM SC WHERE C#="C2")
D.SELECT S# FROM SC WHERE C#="C2" AND GRADE> =ALL(SELECT GRADE FROM SC WHERE C#="C2")