• 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 FORM sc WHERE c
    L: =’C2’);
    M: SELECT s
    N: FROM sc WHERE c
    O: =’C2’ AND grade>=(SELECT max(grade) FROM sc WHERE c
    P: =’C2’);
  • 举一反三