题目：检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是____。
A. SELECT S＃ FORM SC WHERE C＃=’C2’ AND GRADE>= (SELECT GRADE FORM SC WHERE C＃=’CZ’)
B. SELECT S＃ FORM SC WHERE C＃=’C2’ AND GRADE IN (SELECT GRADE FORM SC 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＃ FROM SC WHERE C＃=’C2’AND GRADE>=ALL (SELECT GRADE FROM SC WHERE C＃=’C2’)
答案：评论后可见此内容
