当前位置:百科知识 > 等级考试

问题描述:

[单选] 检索选修课程 "C2"的学生中成绩最高的学生的学号。正确的SeLECT 的语句是
A.SELECT S# FORM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FORM SC) WHERE C#="C2") B.SELECT S#FORM SC WHERE C#="C2" AND GRADE IN(SELECT CRADE FORM SC) WHERE C#="C2" C.SELECT S# FORM SWHERE C#="C2" AND CRANDE> =ALL(SELECT GRADE FORM SWHERE C#="C2") D.SELECT S# FORM SC WHERE C#="C2"ANGRADE NOT IN(SELECT GRADE FORM SC WHERE C#="C2")
参考答案:查看
答案解析:
☆收藏

随机题目