OCP-1Z0-051 第14题 DISTINCT去重

最新推荐文章于 2019-11-25 17:02:39 发布

hello_holly

最新推荐文章于 2019-11-25 17:02:39 发布

阅读量5.9k

点赞数 4

CC 4.0 BY-SA版权

分类专栏： OCP-1Z0-051 文章标签： OCP-1Z0-051 DISTINCT 去重 11g

本文链接：https://blog.csdn.net/holly2008/article/details/23218757

在Oracle数据库考试中，OCP-1Z0-051的第14题要求从CUSTOMERS表中生成一个报告，显示每个收入级别下50%的信用额度，且不重复。解答这个问题需要正确使用DISTINCT关键字。选项C是正确答案，因为它使用DISTINCT结合字符串连接去除每个收入级别下的重复信用额度，而其他选项存在语法错误或未正确处理重复值。

一、原题

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;