OCP-1Z0-051-2015-43题
来源:互联网 发布:郑州八度网络 编辑:程序博客网 时间:2024/06/05 08:30
QUESTION NO: 43
What would be the outcome of executing the above SQL statement?
A. It produces an error
B. It shows the names of products whose list price is the second highest in the table.
C. It shown the names of all products whose list price is less than the maximum list price
D. It shows the names of all products in the table
Answer: B
Exhibit contains the structure of PRODUCTS table:
What would be the outcome of executing the above SQL statement?
A. It produces an error
B. It shows the names of products whose list price is the second highest in the table.
C. It shown the names of all products whose list price is less than the maximum list price
D. It shows the names of all products in the table
Answer: B
Explanation:
1、语句可以出结果,A错误
2、拆分上面sql语句,首先运行子句查询出价格最高的产品的价格
sh@TESTDB> SELECT MAX(prod_list_price)FROM products;
MAX(PROD_LIST_PRICE)
--------------------
1299.99
3、低于价格最高的,即价格次高的产品。按题意,故选C.
sh@TESTDB> SELECT MAX(prod_list_price)FROM products
2 WHERE prod_list_price < 1299.99;
MAX(PROD_LIST_PRICE)
--------------------
1099.99
0 0
- OCP-1Z0-051-2015-43题
- 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题
- java 压缩和解压lzo文件
- 遍历Map的四种方法
- thinkphp 3.2 =》0623-7 调用数据库
- @NotNull和@NotEmpty和@NotBlank区别
- 友盟分享集成
- OCP-1Z0-051-2015-43题
- 常用WebService(逐渐更新)
- 人脸检测“Face detections without bells and whistles”
- 关于IOS9的本地通知方法
- wdcp 升级PHP5.3版本,自带支持pdo_mysql组件方法
- struts2的核心
- eclipse 的 working set 里,open project 重复显示的问题
- 页面响应事件跳转的两种方法
- 网络层—路由选择协议