专业、全面、易懂的全领域名词百科

已知选课关系SC(S#char(8),C#char(8),GRADEinteger)，S#学号，C#课程号，GRADE成绩。检索选修课程'C2'的学生中成绩最高的学生的学号。正确的SELECT语句是（）。

题型：单选题

选项

A. SELECT S# FROM SC WHERE C#='C2' AND GRADE >= ALL(SELECT GRADE FROM SC WHERE C#='C2')

B. SELECT S# FROM SC WHERE C#='C2' AND GRADE >=(SELECT GRADE FROM SC WHERE C#='C2')

C. SELECT S# FROM SC WHERE C#='C2' AND GRADE IN (SELECT GRADE FROM SC WHERE C#='C2')

D. SELECT S# FROM SC WHERE C#='C2' AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#='C2')

正确答案：A

名词解析