OCP-1Z0-051-V9.02-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;

 

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不应该放在第二列，应该放在第一列中

sh@TESTDB> SELECT DISTINCT  cust_income_level,cust