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

最新推荐文章于 2016-03-15 20:16:47 发布

今年我18

最新推荐文章于 2016-03-15 20:16:47 发布

阅读量498

点赞数

分类专栏： 1z0-051 文章标签： 1z0-051

本文链接：https://blog.csdn.net/dwj19830118/article/details/50818038

版权

1z0-051 专栏收录该内容

175 篇文章 1 订阅

订阅专栏

111.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
解析：题目说要显示在每个income level，每个city 中的最高的 credit limit
因此直接按照他俩进行group by就行了，因此选择b