OCP-1Z0-051 第63题 order by 应用

一、原题

View the Exhibit and examine the structure of the PRODUCTS table.

You want to display only those product names with their list prices where the list price is at least double the minimum price. The report should start with the product name having the maximum list price satisfying this condition.

Evaluate the following SQL statement:

SQL>SELECT prod_name,prod_list_price

FROM products

WHERE prod_list_price >= 2 * prod_min_price

Which ORDER BY clauses can be added to the above SQL statement to get the correct output?

(Choose all that apply.)

A. ORDER BY prod_list_price DESC, prod_name;

B. ORDER BY (2 * prod_min_price) DESC, prod_name;

C. ORDER BY prod_name, (2 * prod_min_price) DESC;

D. ORDER BY prod_name DESC, prod_list_price DESC;

E. ORDER BY prod_list_price DESC, prod_name DESC;

答案：AE

二、题目翻译

查看PRODUCTS表的结构：

现在想显示产品价格是最低价格两倍的产品的名称.报表应该以价格列表中的最高价格的产品名称开始（即先按价格列表的降序排序，再按名称排序，但这里没有说是按升序还是降序）。

下面的SQL语句:

哪一个ORDER BY子句加到上面的SQL语句后能得到正确的结果？(选择所有正确的选项)

三、题目解析

题目的意思，先按prod_list_price降序排序, 再按prod_name排序

B选项不正确，因为是按2*prod_min_price排序，所以不正确。

C和D选项不正确，都是先按prod_name排序。