• 2022-10-26
    检索选修课程‘C2’的学生中成绩最高的学生的学号。正确的SELECT语句是( )。
    A: SELECT S
    B: FORM SCWHERE C
    C: =‘C2’ AND GRADE>=(SELECT GRADE FORM SCWHERE C
    D: =‘C2’)
    E: SELECT S
    F: FORM SCWHERE C
    G: =‘C2’ AND GRADE IN(SELECT GRADE FORM SCWHERE C
    H: =‘C2’)
    I: SELECT S
    J: FORM SCWHERE C
    K: =‘C2’ AND GRADE NOT IN(SELECT GRADE FORM SCWHERE C
    L: =‘C2’)
    M: SELECT S
    N: FORM SCWHERE C
    O: =‘C2’ AND GRADE>=ALL(SELECT GRADE FORM SCWHERE C
    P: =‘C2’)
  • 举一反三