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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11312660/viewspace-718954/