Which options when used with the above SQL statement can produce the sorted output in ascending order of the price…

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.)

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_informatio.

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



Leave a Reply 2

Your email address will not be published. Required fields are marked *


user

user

select job, sal s from emp order by s;

user

user

select job, sal+100 s from emp order by sal+100;