Which query would give the required result? (Choose all that apply.)
A. SELECT promo_name,promo_begin_date FROM promotions WHERE promo_begin_date > ’01-JAN-01′ ORDER BY 1 DESC;
B. SELECT promo_name,promo_begin_date “START DATE” FROM promotions WHERE promo_begin_date > ’01-JAN-01′ ORDER BY “START DATE” DESC;
C. SELECT promo_name,promo_begin_date FROM promotions WHERE promo_begin_date > ’01-JAN-01′ ORDER BY 2 DESC;
D. SELECT promo_name,promo_begin_date FROM promotions WHERE promo_begin_date > ’01-JAN-01′ ORDER BY promo_name DESC;
Answer:B
Which query would give the required result? (Choose all that apply.)
A. SELECT promo_name,promo_begin_date FROM promotions WHERE promo_begin_date > ’01-JAN-01′ ORDER BY 1 DESC; B. SELECT promo_name,promo_begin_date “START DATE” FROM promotions WHERE promo_begin_date > ’01-JAN-01′ ORDER BY “START DATE” DESC; C. SELECT promo_name,promo_begin_date FROM promotions WHERE promo_begin_date > ’01-JAN-01′ ORDER BY 2 DESC; D. SELECT promo_name,promo_begin_date FROM promotions WHERE promo_begin_date > ’01-JAN-01′ ORDER BY promo_name DESC;