题目
A.SELECT S# FROM SC WHERE C#=”C2” AND GRADE>=(SELECT GRADE FROM SC WHERE C#= “C2”)
B.SELECT S# FROM SC WHERE C#=”C2” AND GRADE IN (SELECT GRADE FROM SC WHERE C#= “C2”)
C.SELECT S# FROM SC WHERE C#=”C2” AND GRADE NOT IN (SELECT GRADE FROM SC WHERE C#= “C2”)
D.SELECT S# FROM SC WHERE C#=”C2” AND GRADE>=ALL (SELECT GRADE FROM SC WHERE C#= “C2”)
第1题
A.SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN=”王华”)
B.SELECT SN,AGE,SEX FROM S WHERE SN=”王华”
C.SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE WHERE SN=”王华”)
D.SELECT SN,AGE,SEX FROM S WHERE AGE>王华.AGE
第2题
第3题
A.SELECT S.SN,SC.C#,SC.GRADE FROM S WHERE S.S#=SC.S#
B.SELECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S.S#=SC.GRADE
C.SELECT S.SN,SC.C#,SC.GRADE FROM S,SC
D.WHERE S.S#=SC.S# SELECT S.SN,SC.C#,SC.GRADE FROM S,SC
第4题
A.SELECT S# FROM SC WHERE C#=C2 AND GRADE>=(SELECT GRADE FROM SC WHERE C#=C2)
B.SELECT S# FROM SC WHERE C#=C2 AND GRADE IN(SELECT GRADE FROM SC WHERE C#=C2)
C.SELECT S# FROM SC WHERE C#=C2 AND GRADE NOT IN (SELECT GRADE GORM SC WHERE C#=C2)
D.SELECT S# FROM SC WHERE C#=C2 AND GRADE>=ALL(SELECT GRADE FROM SC WHERE C#=C2)
第5题
A.SELECT SN,AGE,SEX FROM S WHERE SN=“王华”
B.SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE FROM S WHERE SN=“王华”)
C.SELECT SN,AGE,SEX FROM S WHERE AGE>(SELECT AGE WHERE SN=“王华”)
D.SELECT SN,AGE,SEX FROM S WHERE AGE>王华.AGE
第6题
A.(1)处填:count(*)
B.(1)处填:count(学号)
C.(2)处填:学号
D.(2)处填:课程号
第7题
A.select 姓名 from 学生表 where 学号 in (select 学号 from 选课表 where 成绩<80)
B.select 姓名 from 学生表 where 学号 =(select 学号 from 选课表 where 成绩<80)
C.select 姓名 from 学生表 join 选课表 on 学生表.学号=选课表.学号 and 成绩<80
D.select 姓名 from 学生表,选课表 where 学生表.学号=选课表.学号 and 成绩<80
第8题
A.SELECT S#, SN, CN, GRADE FROM S, SC, C WHERE CN=“数据库原理”
B.SELECT S#, SN, CN, GRADE FROM S, SC, C WHERE S.S#=SC.S# AN CN=“数据库原理”
C.SELECT S#, S.SN, CN, GRADE FROM S, SC, C WHERE S.S#=SC.S# AND C.C#=SC.S# AND CN=“数据库原理”
D.SELECT S.S#, SN, CN, GRADE FROM S, SC, C WHERE S.S#=SC.S# AND C.C#=SC.S# AND CN=“数据库原理”
第9题
A.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE BETWEEN 15 AND 19;
B.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE <= 19 AND SAGE >= 15;
C.SELECT * FROM S WHERE SDEP = ‘CS’ OR SAGE BETWEEN 15 AND 19;
D.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE <= 19 OR SAGE >= 15;
第10题
A.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE BETWEEN 15 AND 19;
B.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE <= 19 AND SAGE >= 15;
C.SELECT * FROM S WHERE SDEP = ‘CS’ OR SAGE BETWEEN 15 AND 19;
D.SELECT * FROM S WHERE SDEP = ‘CS’ AND SAGE <= 19 OR SAGE >= 15;
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!