检索选修课程“ c2 ”的学生中成绩最高的学生的。正确的 select 语句是
A.
select sno from sc where cno=’c2’ and grade >= (select grade from sc where cno=’c2’)
B.
select sno from sc where cno=’c2’ and grade in (select grade from sc where cno=’c2’)
C.
select sno from sc where cno=’c2’ and grade not in (select grade from sc where cno=‘c2’)
D.
select sno from sc where cno=’c2’ and grade>=all (select grade from sc where cno=‘c2’)