Examine the description of the PROMOTIONS table:
You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)
A. SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;
B. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
C. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
D. SELECT DISTINCT promo_cost ||’ in ‘|| DISTINCT promo_category FROM promotions ORDER BY 1;
E. SELECT promo_cost, promo_category FROM promotions ORDER BY 1;
|
Download Printable PDF. VALID exam to help you PASS. |
 |
AB
A and B are correct, DISTINCT can only be used once in a select statement and also should be before any column name
A and B are correct, DISTINCT cannot be used more than once with same SELECT query and also it must be used FIRST before any column name
AB i think
AB
AB
C is incorrect