当前位置:百科知识 > 数据库技术

问题描述:

[单选] 检索选修课为“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")
参考答案:查看
答案解析:
☆收藏

随机题目