33. View the Exhibit and examine the details of the ORDER_ITEMS table.
Evaluate the following SQL statements:
Statement 1:
SELECT MAX(unit_price*quantity) "Maximum Order" FROM order_items.
Statement 2:
SELECT MAX(unit_price*quantity) "Maximum Order" FROM order_items
GROUP BY order_id.
Which statements are true regarding the output of these SQL statements?
(Choose all that apply.)
A. Statement 1 would return only one row of output.
B. Both the statements would give the same output.
C. Statement 2 would return multiple rows of output.
D. Statement 1 would not return any row because the GROUP BY clause is missing.
E. Both statements would ignore NULL values for the UNIT_PRICE and QUANTITY
columns.
Answer: ACE
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718807/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
