OCP-1Z0-051-2015-37题
来源:互联网 发布:python论坛源码 编辑:程序博客网 时间:2024/06/05 09:29
You need to display names and grades of customers who have the highest credit limit.
Which two SQL statements would accomplish the task? (Choose two.)
A.
SELECT custname, grade
FROM customers, grades
WHERE (SELECT MAX(cust_credit_limit)
FROM customers) BETWEEN startval and endval;
B.
SELECT custname, grade
FROM customers, grades
WHERE (SELECT MAX(cust_credit_limit)
FROM customers) BETWEEN startval and endval
AND cust_credit_limit BETWEEN startval AND endval;
C.
SELECT custname, grade
FROM customers, grades
WHERE cust_credit_limit = (SELECT MAX(cust_credit_limit)
FROM customers)
AND cust_credit_limit BETWEEN startval AND endval;
D.
SELECT custname, grade
FROM customers , grades
WHERE cust_credit_limit IN (SELECT MAX(cust_credit_limit)
FROM customers)
AND MAX(cust_credit_limit) BETWEEN startval AND endval;
Answer: B,C
Explanation:题意要求显示有最高credit limit的用户的名称和等级,但是须在startval endval 之间。
确定最大值所在的级别,但第二个条件cust_credit_limit BETWEEN startval AND endval;会把比最大值小,但
同属一个级别的顾客检索出来。
D语法错误,后一个条件里的分组函数不应出现(此处应该用子查询)
- OCP-1Z0-051-2015-37题
- OCP-1Z0-051-2015-1题
- OCP-1Z0-051-2015-2题
- OCP-1Z0-051-2015-3题
- OCP-1Z0-051-2015-4题
- OCP-1Z0-051-2015-5题
- OCP-1Z0-051-2015-6题
- OCP-1Z0-051-2015-7题
- OCP-1Z0-051-2015-8题
- OCP-1Z0-051-2015-9题
- OCP-1Z0-051-2015-10题
- OCP-1Z0-051-2015-11题
- OCP-1Z0-051-2015-12题
- OCP-1Z0-051-2015-13题
- OCP-1Z0-051-2015-14题
- OCP-1Z0-051-2015-15题
- OCP-1Z0-051-2015-16题
- OCP-1Z0-051-2015-17题
- 为什么在Pool中传递Queue对象无法运行
- OpenGL ES(4)——使用投影和Camera Views
- 利用doxygen生成python文档
- java.lang.outofMemoryError解决方法
- Codis作者黄东旭细说分布式Redis架构设计和踩过的那些坑
- OCP-1Z0-051-2015-37题
- Google Java编程风格指南中文版
- eclipse中如何修改不同后缀文件类型的编码
- 最快的Json框架-Jfire-codejson解析
- 软件开发资源
- hdu 1203 I NEED A OFFER! (01背包)
- return 开发时新的
- ios block学习
- Jecc(java椭圆曲线加密库)学习笔记及ECDH实现