设有S(学号,姓名,性别)和SC(学号,课程号,成绩)两个表,如下SQL语句检索选修的每门课程的成绩都高于或等于85分的学生的学号、姓名和性别,正确的是( )。
A、SELECT学号,姓名,性别FROM S WHERE EXISTS(SELECT * FROM SC WHERE SC.学号=S.学号AND成绩<=85)
B、SELECT学号,姓名,性别FROM S WHERE NOT EXISTS(SELECT * FROM SC WHERE SC.学号=S.学号AND成绩<=85)
C、SELECT学号,姓名,性别 FROM S WHERE EXISTS(SELECT * FROM SC WHERE SC.学号=S.学号AND成绩>85)
D、SELECT学号,姓名,性别FROM S WHERE NOT EXISTS(SELECT*FROM SC WHERE SC.学号=S.学号AND成绩<85)
相关问题推荐
-
对模板支撑架有哪些要求?
-
基于Excel数据表可以建立图表,在建立图表后若选择了图表,Excel 2010窗口中将自动出现“图表工具”,不是“图表工具”所具有的选项卡是()。
A、“设计”
B、“布局”
C、“格式”
D、“编辑”
-
When an administrator is troubleshooting a system, which of the following describes the NEXT course of action if a change does not solve the problem?()
A、 Establish a new theory of probable cause.
B、 Reverse the change.
C、 Implement the next logical change.
D、 Perform a root cause analysis.
-
Which of the following is a best practice that can be used to ensure consistency when building systems?()
A、Server build checklist
B、Server baselining tools
C、Architecture diagrams
D、Hardware compatibility list
-
最经常地被用来识别风险的技术是:()
A、面谈
B、DELPHI技术
C、图表
D、头脑风暴