OCP-1Z0-051 补充题库第7题 ORDER BY 子句

最新推荐文章于 2021-08-26 15:13:52 发布

hello_holly

最新推荐文章于 2021-08-26 15:13:52 发布

阅读量2.7k

点赞数

分类专栏： OCP-1Z0-051 文章标签： OCP-1Z0-051 ORDER BY SELECT 11g

本文链接：https://blog.csdn.net/holly2008/article/details/26992937

版权

该博客探讨了两道关于Oracle SQL的ORDER BY子句题目，指出尽管语法形式不同，但两道题目的SQL语句实际上产生相同的结果。ORDER BY 2表示根据查询结果的第二列进行排序，因此无需DESC也可默认为降序，选项A被确认为正确答案。

摘要由CSDN通过智能技术生成

一、原题

Evaluate these two SQL statements:
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC;
SELECT last_name, salary, hire_date FROM EMPLOYEES 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

二、题目翻译

评估下面两句SQL语句: