• 2022-10-26
    检索选修课程‘C2’的学生中成绩最高的学生的学号。正确的select语句为( )。
    A: select S
    B: from sc where C
    C: =‘C2’and grade>= (select grade from sc where C
    D: =‘C2’)
    E: select S
    F: from sc where C
    G: =‘C2’and grade in (select grade from sc where C
    H: =‘C2’)
    I: select S
    J: from sc where C
    K: =‘C2’and grade not in (select grade from sc where C
    L: =‘C2’)
    M: select S
    N: from sc where C
    O: =‘C2’and grade>=all (select grade from sc where C
    P: =‘C2’)
  • 举一反三