检索选修课程 “C2” 的学生中成绩最高的学生的学号。正确的 SELECT 语句是 。
A.
SELECT S# FORM SC WHERE C#='C2' AND GRADE>= (SELECT GRADE FORM SC WHE
B.
SELECT S# FORM SC WHERE C#='C2' AND GRADE IN (SELECT GRADE FORM SC
C.
SELECT S# FORM SC WHERE C#='C2' AND GRADE NOT IN (SELECT GRADE FORM SC
D.
SELECT S# FORM SC WHERE C#='C2' AND GRADE>=ALL (SELECT GRADE FORM SC