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

Oracle认证考试

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

Evaluate these two SQL statements:SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC; What is true about them?()

  • A、The two statements produce identical results.
  • B、The second statement returns a syntax error.
  • C、There is no need to specify DESC because the results are sorted in descending order by default.
  • D、The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题