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