Oracle Certificate Profession 1Z0-051-14

LuiseDalian發表於2014-05-09
Oracle
（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. Which query would give the required result?

A.SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers;

B. SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers;

C.SELECT DISTINCT cust_income_level || cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers;

D. SELECT cust_income_level || cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers;


答案：（C）

解析：

A. DISTINCT關鍵字只能出現在第一列之前。

B. 一個SELECT語句上只能出現一個DISTINCT關鍵字



來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1157185/，如需轉載，請註明出處，否則將追究法律責任。

相關文章