单选题设有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学号,
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)
更多“单选题设有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学号,”相关问题