66.View the Exhibit and examine the data in the COSTS table.
来源:互联网 发布:java 圣思园教程百度云 编辑:程序博客网 时间:2024/05/16 05:27
66.View the Exhibit and examine the data in the COSTS table.
You need to generate a report that displays the IDs of all products in the COSTS table whose unit price is
at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of the unit cost.
You issue the following query:
SQL>SELECT prod_id
FROM costs
WHERE unit_price >= unit_cost * 1.25
ORDER BY unit_cost * 0.25 DESC;
Which statement is true regarding the above query?
A.It executes and produces the required result.
B.It produces an error because an expression cannot be used in the ORDER BY clause.
C.It produces an error because the DESC option cannot be used with an expression in the ORDER BY clause.
D.It produces an error because the expression in the ORDER BY clause should also be specified in the SELECT clause.
答案:A
You need to generate a report that displays the IDs of all products in the COSTS table whose unit price is
at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of the unit cost.
You issue the following query:
SQL>SELECT prod_id
FROM costs
WHERE unit_price >= unit_cost * 1.25
ORDER BY unit_cost * 0.25 DESC;
Which statement is true regarding the above query?
A.It executes and produces the required result.
B.It produces an error because an expression cannot be used in the ORDER BY clause.
C.It produces an error because the DESC option cannot be used with an expression in the ORDER BY clause.
D.It produces an error because the expression in the ORDER BY clause should also be specified in the SELECT clause.
答案:A
0 0
- 66.View the Exhibit and examine the data in the COSTS table.
- 85.View the Exhibit and examine the structure and data in the INVOICE table.
- 107.View the Exhibit and examine the structure and data in the INVOICE table.
- 15.View the Exhibit and examine the data in the CUSTOMERS table.
- 17.View the Exhibit and examine the data in the EMPLOYEES table.
- 53.View the Exhibit and examine the data in the PROMOTIONS table.
- 59.View the Exhibit and examine the data in the PRODUCTS table.
- 126.View the Exhibit and examine the data in the PROJ_TASK_DETAILS table.
- 130.View the Exhibit and examine the data in the EMPLOYEES table:
- 150.View the Exhibit and examine the data in the PROMOTIONS table.
- 64.View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of
- 79.View the Exhibit and examine the structure of the CUSTOMERS table. In the CUSTOMERS table, the CU
- 92.View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the PROMOTI
- 97.View the Exhibit and evaluate the structure and data in the CUST_STATUS table.
- 169.View the Exhibit and examine the description for the PRODUCTS and SALES table.
- 8.View the Exhibit and examine the structure of the CUSTOMERS table.
- 11.View the Exhibit and examine the structure of the PRODUCTS table.
- 13.View the Exhibit and examine the structure of the PRODUCTS table.
- 怎么快速创建ABBYY Mac中自动化任务
- 细数ARM与Intel在半导体行业这些年的那些事
- 《AngularJS》5个实例详解Directive(指令)机制
- 《JAVA编程思想》日志(五)--------初始化与清理
- 生成流水号
- 66.View the Exhibit and examine the data in the COSTS table.
- SurfaceView
- 02-创建一个ROS的WorkSpace目录
- Ubuntu 14.04 移动mysql 数据库
- iOS拨打电话(三种方法)
- Hibernate主从数据库读写分离配置
- Java多线程(八)——死锁
- android 源码编译注意事项
- iOS_缩短app启动时间的一些见解