• 2022-05-30
    查询选修了课程号为“C2”的学生号和姓名,若用下列SQL的SELECT语句表达时,()是错误的。
    A: SELECT S.S#,SNAME FROM S WHERE S.S#
    B: =(SELECT SC.S#FROM SC WHERE C#='C2')
    C: SELECT S.S#,SNAME FROM S,SC
    D: WHERE S.S#=SC.S# AND C#='C2'
    E: SELECT S.S#,SNAME FROM S,SC
    F: WHERE S.S#=SC.S# AND C#='C2' ORDER BY S.S#
    G: SELEC S.S#,SNAME FROM S WHERE S.S#
    H: IN(SELECT SC.S# FROM SC WHERE C#='C2')
  • 举一反三