问题
单项选择题
检索选修课程号为“D3”的学生中成绩最高的学生的学号，正确的、SELECT语句是______
A．SELECT S#
FROM SC
WHERE C#='D3'AND GRADE＞=
(SELECT GRADE FROM SC
WHERE C#='D3')；
B．SELECT S#
FROM SC
WHERE C#='D3'AND GRADE IN
(SELECT GRADE FROM SC
WHERE C#='D3')；
C．SELECT S#
FROM SC
WHERE C#='D3'AND GRADE NOT IN
(SELECT GRADE FROM SC
WHERE C#='D3')；
D．SELECT S#
FROM SC
WHERE C#='D3'AND GRADE＞=ALL
(SELECT GRADE FROM SC
WHERE C#='D3')；
答案
参考答案：D