单选题
检索选修课程"C2"的学生中成绩最高的学生的学号。正确的SELECT的语句是______。
A、
SELECT S# FORM SC
WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC)
WHERE C#="C2")
B、
SELECT S#FORM SC
WHERE C#="C2" AND GRADE IN(SELECT CRADE 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# FORM SC
WHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SC
WHERE C#="C2")
【正确答案】
D
【答案解析】
提交答案
关闭