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
解析:题里说不要重复的,因此排除D,这道题考察的是distinct,distinct必须放到开头,因此排除A和B
因此选择C
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
解析:题里说不要重复的,因此排除D,这道题考察的是distinct,distinct必须放到开头,因此排除A和B
因此选择C