• 2022-05-30
    查询选修了课程号为“C1”的学生的姓名和年龄,若用下列SQL的SELECT语句表达时,错误的是( )。
    A: SELECT SNAME,AGE FROM S WHERE
    B: S#=(SELECT S
    C: S#FROM SC WHERE
    D: C#='C1')
    E: SELECT SNAME,AGE FROM S,SC WHERE
    F: S#=S
    G: S# AND S
    H: C#='C1'
    I: SELECT SNAME,AGE FROM S,SC WHERE
    J: S#=S
    K: S# AND S
    L: C#='C1' ORDERBY
    M: S#
    N: SELECT SNAME,AGE FROM S WHERE
    O: S#=(SELECT S
    P: S# FROM SC WHERE S
    Q: C#='C1')
  • 举一反三