查询选修了课程号为'C2'的学生号和姓名，若用下列SQL的SELECT语句表达时，哪一个是错误的?

A．SELECT S．S#，SNAME FROM S WHERE S．S#=(SELECT S

C．S# FROM SC WHERE C#=‘C2’)

B．SELECT S．S#，SNAME FROM S，SCWHERE S．S#=S

C．S#AND C#=‘C2’

C．SELECT S．S#，SNAME FROM S，SCWHERE S. S#=S

C．S#AND C#=‘C2’ORDER BY S．S#

D．SELECT S．S#，SNAME FROM S WHERE S．S#IN (SELECT S

C．S# FROM SC WHERE C#=‘C2’)

[单选题]查询选修了课程号为'C2'的学号和姓名，若用下列SQL的SELECT语句表达时，哪一个是不正确的? ( )A．SELECTS. S#，SNAMEFROMS WHERE S. S#=(SELECTSC)S# FROMSC WHERE C#='C2'B．SELECTS．S#，SNAMEFROMS，SC WHERES．S#=SC.S# AND C#='C2'C．SELECTS．S#，SNAME FROM S，SC WHERES．S#=SC.S# AND C#='C2'ORDER BY

[单选题]查询选修了课程号为/'C2/'的学生号和姓名，若用下列SQL的SELECT语句表达时，哪一个是错误的？A．SELECT S.S#，SNAME FROM S WHERE S.S#= （SELECT SC．S# FROM SC WHERE C# = 'C2' ）B．SELECT S.S#，SNAME FROM S，SCWHERE S.S# = SC．S# AND C# = 'C2'C．SELECT S.S#，SNAME FROM S，SCWHERE S.S# = SC．S# AND C#

[单选题]查询选修了课程号为/'C2/'的学生号和姓名，若用下列SQL的SELECT语句表达时，哪一个是错误的?______。A．SELECT S.S#,SNAME FROM S WHERE S.S#=(SELECT SC.S# FROM SC WHERE C#=/'C2/')B．SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND C#=/'C2/'C．SELECT S.S#,SNAME FROM S,SC WHERE S.S#=SC.S# AND

[单选题]查询选修了课程号为“C2”的学生号和姓名，若用下列SQL的SELECT语句表达时，哪一个是错误的?A．SELECT S.S#，SNAME FROM S WHERE S.S# (SELECT SC. S# FROM SC WHERE C#='C2')B．SELECT S.S#，SNAME FROMS，SC WHERE S.S#=SC.S# AND C#='C2'C．SELECT S.S#，SNAME FROM S,SC WHERE S.S=SC．S# AND C#='C2'ORDER

[单选题]查询选修了课程号为，C2，的学生号和姓名，若用下列SQL的SELECT语句表达时，错误的是( )。A．SELECT S.S#，SNAME FROM S WHERE S.S# =(SELECT SC.S# FROM SC WHERE C#='C2')B．SELECT S.S#，SNAME FROM S，SC WHERE S.S#=SC.S# AND C#='C2')C．SELECT S.S#，SNAME FROM S，SC WHERE S.S#=SC.S# AND C#='C2' OR

[单选题]查询选修了课程号为“C2”的学生号和姓名，若用下列SQL的SELECT语句表达是，（ ）是错误的。 A．SELECT S.S＃，SNAME FROM S WHERE S.S＃ =（SELECT SC.S＃FROM SC WHERE C＃=＇C2＇） B．SELECT S.S＃，SNAME FROM S，SC WHERE S.S＃=SC.S＃ AND C＃=＇C2＇ C．SELECT S.S＃，SNAME FROM S，SC WHERE S.S＃=SC.S＃ AND C＃=＇C2＇ORDER BY

[单选题]查询选修了课程号为“C1”的学生的姓名和年龄，若用下列SQL的SELECT语句表达 时，错误的是（ ）。A．SELECT SNAME，AGE FROM S WHERE S ．S#=（SELECT SC．S# FROM SC WHERE C．C#=’C 1’） B．SELECT SNAME，AGE FROM S，SC WHERE S．S#=SC．S# AND SC．C#=’C 1’ C．SELECT SNAME，AGE FROM S，SC WHERE S．S#=SC．S# AND SC．C#=’C

[单选题]查询“选修了课程号C#='C2'的学生的学生号”，正确的表示是( )。Ⅰ. ∏S#(OC#='C2'(SC) ) Ⅱ. OC#='C2'(∏S#(S))Ⅲ. SELECT S#FROM SC WHERE C#='C2'A．) 仅Ⅰ和ⅡB．) 仅Ⅱ和ⅢC．) 仅Ⅰ和ⅢD．) 都正确A．B．C．D．

[单选题]查询选修了课程号为“MATHS”的学生的姓名和年龄，若用下列SQL的SELECT语句表达时，错误的是（ ）。A．) SELECT SNAME,AGE FROM S WHERE S. S# =(SELECT SC． S# FROM SC WHEREc.c# ='MATHS ')B． ) SELECT SNAME, AGE FROM S WHERE S. S# =(SELECT SC． S# FROM SC WHERESC． C# =' MATHS ')C．) SELECT SNAME, A

[单选题]查询“选修了课程号 C# ='C2'的学生的学生号”，正确的表示是I．π s#（σ c#='c2'（SC）） II．σ c#='c'（π s#（S））III ．SELECT S# FROM SC WHERE C#＝'C2'A．）仅 I和IIB．）仅 II和 IIIC． )仅I和 IIID．）都正确