本文探讨了如何使用特定的SQL语句从PRODUCTS表中选择产品名称及其列表价格，条件是列表价格至少为最低价格的两倍，并按满足条件的最大列表价格的产品名称开始显示报告。文章详细解释了正确的ORDER BY子句应用。
63. View the E xhibit 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;
Answer: AE 答案解析：
The report should start with the product name having the maximum list price satisfying this condition.
题意要求按照list price由大到小附加名字来排序，即先保证 prod_list_price是降序的后面按照name来排序，prod_name排序可升序可降序。
扫一扫
7899
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
