ITPub博客

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

047-135

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-19 10:05:08 0 删除 编辑
135. View the Exhibit and examine the description of the PRODUCT_INFORMATION
table.SELECT product_name, list_price, min_price, list_price-min_price
Difference FROM product_information
Which options when used with the above SQL statement can produce the sorted
output in ascending order of the price difference between LIST_PRICE and
MIN_PRICE? (Choose all that apply.)
A. ORDER BY 4
B. ORDER BY MIN_PRICE
C. ORDER BY DIFFERENCE
D. ORDER BY LIST_PRICE
E. ORDER BY LIST_PRICE -MIN_PRICE
Answer: ACE
ORDER BY可以用别名

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718954/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203401