多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar? ()

  • A、SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
  • B、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
  • C、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
  • D、SELECT student_id, gpa FROM student_grades ORDER BY gpa;
  • E、SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
  • F、SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
正确答案:F
答案解析:
进入题库查看解析

微信扫一扫手机做题