OCP-1Z0-051 补充题库 第10题 集合操作中的ORDER BY子句

一、原题

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?
A. It produces an error because the ORDER BY clause should appear only at the end of a
compound query-that is, with the last SELECT statement
B. It executes successfully and displays rows in the descending order of PROMO_CATEGORY
C. It executes successfully but ignores the ORDER BY clause because it is not located at the end
of the compound statement
D. It produces an error because positional notation cannot be used in the ORDER BY clause with
SET operators

答案:A

二、题目翻译

看下面的SQL语句:
下面关于这个SQL语句查询结果的描述，哪一个是正确的?
A.会报错，因为ORDER BY子句只能在最后出现。
B.执行成功，显示的行按PROMO_CATEGORY列的降序排序。
C.执行成功，但是忽略ORDER BY子句，因为它不在复合语句的末尾位置。
D.会报错，因为在集合操作中，不能出现ORDER BY子句。

三、题目解析

集合语句中，ORDER BY子句只能出现在最后，也就是将集合操作完成后的结果排序，否则报错。