问题描述:
[单选]
检索选修课为“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是()。
A.SELECTS#FROMSC WHERE C#="C2"AND GRADE>= (SELECT GRADE FROM SC WHERE C#="C2")
B.SELECTS#FROM SC WHERE C#="C2" AND GRADE IN (SELECT GRADE FROM SC WHELRE C#="C2")
C.SELECT S# FROM S WHERE C#="C2" AND GRADE NOT IN (SELECT‘GRADE FROM S WHERE C#="C2")
D.SELECT’S#FR()M SC WHERE C#="C2" ANGRADE>=ALL (SELECT’GRADE FROM SC WHERE C#="C2")
参考答案:查看无
答案解析:无
☆收藏
答案解析:无
☆收藏
- 我要回答: 网友(216.73.217.42)
- 热门题目: 1.下列题基于“学生—选课—课程 2.以下各题基于以下的叙述:关系 3.试题()()()基于“学生-
