OCP-1Z0-051-V9.02-70题
来源:互联网 发布:贪心算法设计原则 编辑:程序博客网 时间:2024/05/18 16:19
70. View the E xhibit and examine the structure of the PRODUCTS table.
You want to display only those product names with their list prices where the list price is at least double
the minimum price. The report should start with the product name having the maximum list price satisfying
this condition.
Evaluate the following SQL statement:
SQL>SELECT prod_name,prod_list_price
FROM products
WHERE prod_list_price >= 2 * prod_min_price
Which ORDER BY clauses can be added to the above SQL statement to get the correct output?
(Choose all that apply.)
A. ORDER BY prod_list_price DESC, prod_name;
B. ORDER BY (2*prod_min_price)DESC, prod_name;
C. ORDER BY prod_name, (2*prod_min_price)DESC;
D. ORDER BY prod_name DESC, prod_list_price DESC;
E. ORDER BY prod_list_price DESC, prod_name DESC;
Answer: AE
- OCP-1Z0-051-V9.02-70题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-1题
- OCP-1Z0-051-V9.02-11题
- OCP-1Z0-051-V9.02-12题
- OCP-1Z0-051-V9.02-14题
- OCP-1Z0-051-V9.02-15题
- OCP-1Z0-051-V9.02-17题
- OCP-1Z0-051-V9.02-18题
- OCP-1Z0-051-V9.02-21题
- OCP-1Z0-051-V9.02-118题
- OCP-1Z0-051-V9.02-120题
- OCP-1Z0-051-V9.02-32题
- OCP-1Z0-051-V9.02-33题
- OCP-1Z0-051-V9.02-93题
- OCP-1Z0-051-V9.02-94题
- OCP-1Z0-051-V9.02-95题
- Android中Adapter的一点一滴
- OCP-1Z0-051-V9.02-69题
- 简单的php文件上传。一个文件搞定。
- oracle sql 生成日历
- 驴子拉萝卜的问题
- OCP-1Z0-051-V9.02-70题
- windows基于阿帕奇服务器,实现vc++文件下载功能
- 继承和组合
- 打通防火墙,支持远程访问mongodb
- Objective-C语法之继承、封装、多态
- Java工具类——DES加密和解密工具 I
- java面试题
- android中tab的自定义及使用
- HYSBZ 1878 HH的项链