ocpÌâ¿â½âÎö£º11g-1Z0-051-µÚ14Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

14. Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit

amount in each income level. The report should NOT show any repeated credit amounts in each income

level. --each income levelÖÐûÓÐÖظ´µÄcredit amounts

Which query would give the required result?

A.

SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50

AS "50% Credit Limit"

FROM customers;

[sql] view plain copy print?

sh@TESTDB> SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50

2 AS "50% Credit Limit"

3 FROM customers;

SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50

*

ERROR at line 1:

ORA-00936: missing expression

Óï·¨´íÎó£¬DISTINCT²»Ó¦¸Ã·ÅÔÚµÚ¶þÁУ¬Ó¦¸Ã·ÅÔÚµÚÒ»ÁÐÖÐ

[sql] view plain copy print?

sh@TESTDB> SELECT DISTINCT cust_income_level,cust_credit_limit * 0.50

2 AS "50% Credit Limit"

3 FROM customers where rownum<6;

CUST_INCOME_LEVEL 50% Credit Limit

------------------------------ ----------------

G: 130,000 - 149,999 5500

G: 130,000 - 149,999 4500

G: 130,000 - 149,999 3500

G: 130,000 - 149,999 750

B.

SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50

AS "50% Credit Limit"

FROM customers;

ͬA£¬Óï·¨´íÎó£¬DISTINCT²»Ó¦¸Ã·ÅÔÚµÚ¶þ¸ö

[sql] view plain copy print?

SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50

2 AS "50% Credit Limit"

3 FROM customers;

SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50

*

ERROR at line 1:

ORA-00936: missing expression

C.

SELECT DISTINCT cust_income_level ' ' cust_credit_limit * 0.50

AS "50% Credit Limit"

FROM customers;

[sql] view plain copy print?

sh@TESTDB> SELECT DISTINCT cust_income_level ' ' cust_credit_limit * 0.50

2 AS "50% Credit Limit"

3 FROM customers;

SELECT DISTINCT cust_income_level ' ' cust_credit_limit * 0.50

*

ERROR at line 1:

ORA-00923: FROM keyword not found where expected

ÕâµÀÌâÔ¸ÒâΪÓÃ' 'Á¬½ÓÁ½¸öÁУ¬¿ÉÄÜÓÃ´í£¬Ó¦Îª||À´Á¬½Ó£¬²»¹ýDISTINCTµÄλÖà ¶ÔµÄ

[sql] view plain copy print?

sh@TESTDB> SELECT DISTINCT cust_income_level || cust_credit_limit * 0.50

2 AS "50% Credit Limit"

3 FROM customers where rownum<6;

50% Credit Limit

----------------------------------------------------------------------

G: 130,000 - 149,999750

G: 130,000 - 149,9994500

G: 130,000 - 149,9993500

G: 130,000 - 149,9995500

D.

SELECT cust_income_level ' ' cust_credit_limit * 0.50 AS "50% Credit Limit"

FROM customers

DûÓÐÂú×ãNOT show any repeatedµÄÌõ¼þ¡£

´ËÌâ´ð°¸C