OCP¿¼ÊÔÌâ¿â£º11g-1Z0-051-v9.02-018Ìâ

OCP¿¼ÊÔÌâ¿â£º11g-1Z0-051-v9.02-018Ìâ,ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

18. Examine the structure of the PROMOTIONS table:

name Null Type

PROMO_ID NOT NULL NUMBER(6)

PROMO_NAME NOT NULL VARCHAR2(30)

PROMO_CATEGORY NOT NULL VARCHAR2(30)

PROMO_COST NOT NULL NUMBER(10,2)

The management wants to see a report of unique promotion costs in each promotion category.

Which query would achieve the required result?

A. SELECT DISTINCT promo_cost, promo_category FROM promotions;

B. SELECT promo_category, DISTINCT promo_cost FROM promotions;

C. SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;

D. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

AÓëÃèÊöµÄ²»Ò»ÖÂ

BCÓï·¨´íÎó£¬DISTINCT·ÅÔÚµÚ¶þÁÐÒª±¨´í¡£

´ËÌâ´ð°¸Ñ¡D