试题详情
单项选择题 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;

  • 关注下方微信公众号，在线模考后查看

热门试题