• 2022-10-26 问题

    检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是()。 A: SELECTS B: FORMSCWHEREC C: =“C2”ANDGRADE>=(SELECTGRADEFORMSC D: EREC E: =“C2”) F: SELECTS G: FORMSC H: EREC I: =“C2”ANDGRADEIN J: ELECTGRADEFORMSC K: EREC L: =“C2”) M: SELECTS N: FORMSC O: EREC P: =“C2”ANDGRADENOTIN Q: ELECTGRADEFORMSC R: EREC S: =“C2”) T: SELECTS U: FORMSC V: EREC W: =“C2”ANDGRADE>=ALL

    检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT语句是()。 A: SELECTS B: FORMSCWHEREC C: =“C2”ANDGRADE>=(SELECTGRADEFORMSC D: EREC E: =“C2”) F: SELECTS G: FORMSC H: EREC I: =“C2”ANDGRADEIN J: ELECTGRADEFORMSC K: EREC L: =“C2”) M: SELECTS N: FORMSC O: EREC P: =“C2”ANDGRADENOTIN Q: ELECTGRADEFORMSC R: EREC S: =“C2”) T: SELECTS U: FORMSC V: EREC W: =“C2”ANDGRADE>=ALL

  • 2022-10-27 问题

    查询选修了课程号为“C2”的学生中成绩最高的学生的学号,正确的SELECT语句是()。 A: SELECTS B:  FROMSC WHEREC C: ='C2'ANDGRADE>=ALL D:      (SELECTGRADE  FROMSC  WHEREC E: ='C2') F: SELECTS G:  FROMSC WHEREC H: ='C2'ANDGRADEIN I:        (SELECTMAX(GRADE) FROMSC WHEREC J: ='C2') K: SELECTS L:  FROMSC WHEREC M: ='C2'ANDGRADE= N:         (SELECTMAX(GRADE) FROMSC WHEREC O: ='C2') P: SELECTS Q:  FROMSC WHEREC R: ='C2'ANDGRADE>=ANY S:       (SELECTGRADE FROMSC WHEREC T: ='C2')

    查询选修了课程号为“C2”的学生中成绩最高的学生的学号,正确的SELECT语句是()。 A: SELECTS B:  FROMSC WHEREC C: ='C2'ANDGRADE>=ALL D:      (SELECTGRADE  FROMSC  WHEREC E: ='C2') F: SELECTS G:  FROMSC WHEREC H: ='C2'ANDGRADEIN I:        (SELECTMAX(GRADE) FROMSC WHEREC J: ='C2') K: SELECTS L:  FROMSC WHEREC M: ='C2'ANDGRADE= N:         (SELECTMAX(GRADE) FROMSC WHEREC O: ='C2') P: SELECTS Q:  FROMSC WHEREC R: ='C2'ANDGRADE>=ANY S:       (SELECTGRADE FROMSC WHEREC T: ='C2')

  • 1