A.SELECT SNAME,AGE FROM S WHERE S .S#=(SELECT S
C.S# FROM SC WHERE
C.C#=’C 1’)
B.SELECT SNAME,AGE FROM S,SC WHERE S.S#=S
C.S# AND S
C.C#=’C 1’
C.SELECT SNAME,AGE FROM S,SC WHERE S.S#=S
C.S# AND S
C.C#=’CI’ ORDER B Y S.S#
D.SELECT SNAME,AGE FROM S WHERE S.S#=(SELECT S
C.S# FROM SC WHERE S
C.C#=’C 1’)
[单选题]查询选修了课程号为“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
[单选题]查询选修了课程号为/'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'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,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,SCWHERE S.S#=SC.S#AND C#=‘C2’C.SELECT S.S#,SNAME FROM S,SCWHERE S. S#=SC.S#AND C#=‘C2’ORDER BY S.S
[单选题]查询选修了课程号为'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
[单选题]检索“至少选修课程号为′C1′的学生姓名(SNAME) ”的SQL语句是A.SELECT s.sname FROM s,sc WHERE c.cno=′C1′B.SELECT s.sname FROM s,sc WHERE c.cno=′C1′AND s.sno=sc.snoC.SELECT s.sname FROM s,sc FOR c.cno=′C1′D.SELECT s.sname FROM s,sc FOR c.cno=′C1′AND s.sno=sc.sno
[单选题]查询选修 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.)SELE