题目
A.SELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)>=4
B.SELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY 2 DESC
C.SELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT(*)>=4
第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题
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
第3题
第4题
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
第5题
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”)
第6题
A.SELECT sname,age,sex FROM s WHERE sname=‘王华‘
B.SELECT sname,age,sex FROM s WHERE age;王华.age
C.SELECT sname,age,sex FROM s WHERE age;(SELECT age;;FROM s;;WHERE sname=‘王华‘)
D.SELECT sname,age,sex FROM s WHERE age;(SELECT age;; WHERE sname=‘王华‘)
第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 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
第9题
A.SELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)>=4
B.SELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY 2 DESC
C.SELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.SELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT(*)>=4
第10题
A.(1)处填:count(*)
B.(1)处填:count(学号)
C.(2)处填:学号
D.(2)处填:课程号
第11题
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
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!