OCP-1Z0-051 第111题 GROUP BY子句

最新推荐文章于 2023-05-04 09:36:45 发布

hello_holly

最新推荐文章于 2023-05-04 09:36:45 发布

阅读量3.6k

点赞数 1

分类专栏： OCP-1Z0-051 文章标签： OCP-1Z0-051 GROUP BY MAX 11g

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

版权

OCP-1Z0-051 专栏收录该内容

220 篇文章 6 订阅

订阅专栏

一、原题

View the Exhibit and examine the structure of the CUSTOMERS table.

Which statement would display the highest credit limit available in each income level in each city in the CUSTOMERS table?
A. SELECT cust_city, cust_income_level, MAX(cust_credit_limit )
       FROM customers
GROUP BY cust_city, cust_income_level, cust_credit_limit;

B. SELECT cust_city, cust_income_level, MAX(cust_credit_limit)
        FROM customers
GROUP BY cust_city, cust_income_level;

C. SELECT cust_city, cust_income_level, MAX(cust_credit_limit)
        FROM customers
GROUP BY cust_credit_limit, cust_income_level, cust_city ;

D. SELECT cust_city, cust_income_level, MAX(cust_credit_limit)
        FROM customers
GROUP BY cust_city, cust_income_level, MAX(cust_credit_limit);

答案：B

二、题目翻译

查看CUSTOMERS表的结构，
哪条语句显示每个城市中每个收入水平的最高信用额度？

三、题目解析

AC选项不正确，按照题目，应该按城市和收入水平分组，这两个都不正确。
D选项不正确，报错，因为GROUP BY子句中不能使用MAX聚合函数。