70.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
(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
解析:从题目中可以看到要求是list price降序,所以选AE
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
(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
解析:从题目中可以看到要求是list price降序,所以选AE