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