A: SELECT S.S#,SNAME FROM S WHERE S.S#
B: =(SELECT SC.S#FROM SC WHERE C#='C2')
C: SELECT S.S#,SNAME FROM S,SC
D: WHERE S.S#=SC.S# AND C#='C2'
E: SELECT S.S#,SNAME FROM S,SC
F: WHERE S.S#=SC.S# AND C#='C2' ORDER BY S.S#
G: SELEC S.S#,SNAME FROM S WHERE S.S#
H: IN(SELECT SC.S# FROM SC WHERE C#='C2')
举一反三
- 查询选修了课程号为C2的学生号和姓名,用下列SQL的SELECT语句表达时,哪一个是错误的( ) A: SELECT S.S#,SNAME FROM S WHERE S.S# B: =(SELECT SC) S# FROM SC WHERE C#=‘C2’) C: SELECT S.S#,SNAME FROMS,SC D: WHERE S.S# S E: S# AND C#=‘C2’C) SELECT S. S#,SNAME FROM S,SC F: WHERE S.S# SC) S# AND C#=‘C2’ORDER BY S.S# G: SELECT S.S#,SNAME FROM S
- 查询选修了课程号为‘C2’的学生号和姓名,若用下列SQL的SELECT语句表达时, 是错误的? A: SELECT S.S B: ,SNAME FROM S WHERE S C: = (SELECT SS D: FROM SC WHERE C E: =‘C2’) F: SELECT S.S G: ,SNAME FROM S,SC WHERE S H: = SS I: AND C J: =‘C2’ K: SELECT S.S L: ,SNAME FROM S,SC WHERE S M: = SS N: AND C O: =‘C2' ORDER BY S P: Q: SELECT S.S R: ,SNAME FROM S WHERE S S: IN(SELECT SS T: FROM SC WHERE C U: =‘C2' )
- 【单选题】检索学生姓名及其所选修课程的课程号和成绩。正确的 SELECT 语句是 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
- 查询选修了课程号为'C2'的学生号和姓名,若用下列SQL的SELECT语句表达时,哪一个是错误的?() A: SELECT S#,SNAME FROM S WHERE S# = (SELECT SS# FROM SC WHERE C# = 'C2' ) B: SELECT S#,SNAME FROM S,SCWHERE S# = SS# AND C# = 'C2' C: SELECT S#,SNAME FROM S,SC WHERE S# = SS# AND C# = 'C2' ORDER BY S# D: SELECT S#,SNAME FROM S WHERE S# IN (SELECT SS# FROM SC WHERE C# ='C2' )
- 查询选修了课程号为“C1”的学生的姓名和年龄,若用下列SQL的SELECT语句表达时,错误的是( )。 A: SELECT SNAME,AGE FROM S WHERE B: S#=(SELECT S C: S#FROM SC WHERE D: C#='C1') E: SELECT SNAME,AGE FROM S,SC WHERE F: S#=S G: S# AND S H: C#='C1' I: SELECT SNAME,AGE FROM S,SC WHERE J: S#=S K: S# AND S L: C#='C1' ORDERBY M: S# N: SELECT SNAME,AGE FROM S WHERE O: S#=(SELECT S P: S# FROM SC WHERE S Q: C#='C1')
内容
- 0
有关系S(S#,SNAME,SAGE),C(C#,CNAME),SC(S#,C#,GRADE)。若要查找分数(grade)不及格的学生姓名(sname),则以上正确的有?( ) A: SELECT sname FROM s, sc WHERE grade<60 B: SELECT sname FROM s WHERE sno IN(SELECT Cno FROM sc WHERE grade<60) C: SELECT sname FROM s, sc WHERE s.sno=sc.sno AND grade<60 D: SELECT sname FROM s, sc WHERE s.sno=sc.sno OR grade<60
- 1
有关系S(S#,SNAME,SAGE),C(C#,CNAME),SC(S#,C#,GRADE)。若要查找分数(grade)不及格的学生姓名(sname),则以上正确的有?( ) A: SELECT sname FROM s, sc WHERE grade<60 B: SELECT sname FROM s WHERE sno IN(SELECT Cno FROM sc WHERE grade<60) C: SELECT sname FROM s, sc WHERE s.sno=sc.sno AND grade<60 D: SELECT sname FROM s, sc WHERE s.sno=sc.sno OR grade<60
- 2
假设有三个基本表:学生表S、课程表C、学生选课表SC,它们的结构如下:S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE)检索选修课程”C2”的学生中成绩最高的学生的学号。正确的SELECT语句是( )。 A: SELECT S B: FROM SC WHERE C C: =”C2” AND GRADE>=(SELECT GRADE FROM SC WHERE C D: = “C2”) E: SELECT S F: FROM SC WHERE C G: =”C2” AND GRADE IN (SELECT GRADE FROM SC WHERE C H: = “C2”) I: SELECT S J: FROM SC WHERE C K: =”C2” AND GRADE NOT IN (SELECT GRADE FROM SC WHERE C L: = “C2”) M: SELECT S N: FROM SC WHERE C O: =”C2” AND GRADE>=ALL (SELECT GRADE FROM SC WHERE C P: = “C2”)
- 3
查询选修C2课程号的学生姓名,下列SQL语句中错误是 A: SELECT 姓名 FROM S WHERE EXISTS(SELECT * FROM SC WHERE学号=S.学号 AND 课程号="C2") B: SELECT 姓名 FROM S WHERE 学号 IN(SELECT 学号 FROM SC WHERE 课程号="C2") C: SELECT 姓名 FROM S JOIN SC ON S.学号=SC.学号 WHERE 课程号="C2" D: SELECT 姓名 FROM S WHERE 学号=(SELECT 学号 FROM SC WHERE 课程号="C2")
- 4
检索选修课程‘C2’的学生中成绩最高的学生的学号。正确的select语句为( )。 A: select S B: from sc where C C: =‘C2’and grade>= (select grade from sc where C D: =‘C2’) E: select S F: from sc where C G: =‘C2’and grade in (select grade from sc where C H: =‘C2’) I: select S J: from sc where C K: =‘C2’and grade not in (select grade from sc where C L: =‘C2’) M: select S N: from sc where C O: =‘C2’and grade>=all (select grade from sc where C P: =‘C2’)