查询选修了课程号为“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 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')
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')