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

一、原题

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聚合函数。