一起答
单选

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

  • A) SELECT SNAME,AGE 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 FROM S, SC WHERE S. S# =SC. S# AND SC. C# ='MATHS'
参考答案
查看试卷详情