找考题网-背景图
单项选择题

A.SEIECT SNAME, ADE FROM S WHERE S. S#=(SELECT SC. S# F……

查询选修了课程号为“MATHS”的学生的姓名和年龄,若用下列SQL的SELECT语句表达时,错误的是( )。

A.SEIECT SNAME, ADE FROM S WHERE S. S#=(SELECT SC. S# FROM SC
WHERE C.C#='MATHS')
B.SELECT SNAME, AGE FROM S WHERE S. S#=(SELECT SC. S# FROM SC
WHERE SC. C#='MATHS')
C.SELECT SNAME, AGE FROM S, SC WHERE S.S#=SC.S# AND SC. C#='MATHS'
ORDER BY S.S#
D.SELECT SNAME, AGE FROMS, SC WHERE S.S#=SC.S# AND SC.C#='MATHS'
热门试题