111.View the Exhibit and examine the structure of the CUSTOMERS table.
来源：互联网 发布：怎样下载flash软件 编辑：程序博客网 时间：2024/05/23 00:09
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
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
0 0
- 111.View the Exhibit and examine the structure of the CUSTOMERS table.
- 79.View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CU
- 8.View the Exhibit and examine the structure of the CUSTOMERS table.
- 54.View the Exhibit and examine the structure of the CUSTOMERS table.
- 65.View the Exhibit and examine the structure of the CUSTOMERS table.
- 110.View the Exhibit and examine the structure of the CUSTOMERS table.
- 115.View the Exhibit and examine the structure of the CUSTOMERS table.
- 145.View the Exhibit and examine the structure of the CUSTOMERS table.
- 159.View the Exhibit and examine the structure of the CUSTOMERS table.
- 93.View the Exhibit and examine the structure of the CUSTOMERS table. Using the CUSTOMERS table, y o
- 60.View the Exhibit and examine the structure of CUSTOMERS table.
- 1.View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables.
- 151.View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.
- 157.View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables.
- 141.View the Exhibit and examine the structure of CUSTOMERS and GRADES tables.
- 160.View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.
- 164.View the Exhibit and examine the structure of CUSTOMERS and SALES tables.
- 11.View the Exhibit and examine the structure of the PRODUCTS table.
- ranklist
- /proc/meminfo详细
- 【.Net码农】【目录】ASP.Net MVC开发基础学习笔记目录
- 单件模式
- 启动Mediation_Function失败及解决方案
- 111.View the Exhibit and examine the structure of the CUSTOMERS table.
- Map.values方法——获取Map集合中的所有键值对象
- HighCharts 详细使用及API文档说明
- 滴滴出行高效开发保障源动力解析
- 学习网站
- bp神经网络原理及其c++实现
- ubuntu 12.04安装php的权限配制
- 深入理解 KVC\KVO 实现机制 — KVO
- 关于安卓出现No resource found that matches the given name 'Theme.AppCompat.Light 的完美解决方案
