ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 047-033

047-033

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-17 08:57:38 0 删除 编辑
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博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718807/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 047-032
下一篇: 047-034
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203391