题目内容

假设所有学生都已选课,所有的选课成绩都已确定。检索所有选课成绩都在90分以上(含)的学生信息,正确的SQL命令是()。

A. SELECT*FROM学生WHERE学号IN(SELECT学号FROM选课WHERE成绩>=90)
B. SELECT*FROM学生WHERE学号NOT IN(SELECT学号FROM选课 WHERE成绩<90)
C. SELECT*FROM学生WHERE学号!=ANY(SELECT学号FROM选课 WHERE成绩<90)
D. SELECT*FROM学生WHERE学号=ANY(SELECT学号FROM选课 WHERE成绩>=90)

查看答案
更多问题

A.impartedB.immersedC.injectedD.infected

A. imparted
B. immersed
C. injected
D. infected

A.progressB.absenceC.presenceD.favor

A. progress
B. absence
C. presence
D. favor

A.releasedB.relayedC.relievedD.remained

A. released
B. relayed
C. relieved
D. remained

A.moderateB.normalC.unusualD.extreme

A. moderate
B. normal
C. unusual
D. extreme

答案查题题库