题目
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 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 WHERE S.S#=SC.S#
D.SELECT S.SN,SC.C#,SC.GRADE FROM S.SC
第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题
第5题
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
第6题
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 WHERE S.S#=SC.S#
D.SELECT S.SN,SC.C#,SC.GRADE FROM S.SC
第7题
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')
第8题
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
第9题
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 WHERE S.S#=SC.S#
D.SELECT S.SN,SC.C#,SC.GRADE FROM S.SC
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!