已知选课关系SC（S# char（8) C# char（8) GRADE integer) S#学号 C#课程号 GRADE成绩。检索选修课
已帮助 人
已知选课关系SC（S# char（8), C# char（8), GRADE integer)，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")
回答
共1条回复-
SELECT 学号,COUNT(*) FROM 选课 GROUP BY 学号