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

IBM认证考试

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

Given the following query:SELECT last_name, first_name, age, hire_date FROM employee WHERE age > 40Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?()

  • A、SORT BY age ASC, last_name
  • B、SORT BY age DESC, last_name
  • C、ORDER BY age DESC, last_name
  • D、ORDER BY age ASC, last_name
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题