查询选修了课程号为‘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' )
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' )
举一反三
- 查询选修了课程号为‘C2’的学生号和姓名，若用下列SQL的SELECT语句表达时， 是错误的？ A: SELECT S.S B: ，SNAME FROM SWHERE S.S C: = (SELECT SS D: FROM SC WHERE C E: =‘C2’) F: SELECT S.S G: ，SNAME FROM S，SCWHERE S.S H: = SS I: AND C J: =‘C2’ K: SELECT S.S L: ，SNAME FROM S，SCWHERE S.S M: = SS N: AND C O: =‘C2' ORDER BY S.S P: SELECT S.S Q: ，SNAME FROM SWHERE S.S R: IN(SELECT SS S: FROM SC WHERE C T: =‘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 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' )
- 查询选修了课程号为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’的学生中成绩最高的学生的学号。正确的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’)