Which options when used with the above SQL statement can produce the sorted…

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

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

A.
ORDER BY LIST_PRICE

B.
ORDER BY LIST PRICE – MIN PRICE

C.
ORDER BY MIN_PRICE

D.
ORDER BY 4

E.
ORDER BY DIFFERENCE



Leave a Reply 1

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


Ab Hin

Ab Hin

Answer: B, D & E