OCP-1Z0-051-V9.02-155题
来源:互联网 发布:sql server 维护 编辑:程序博客网 时间:2024/06/05 23:51
155. Evaluate the following SQL statement:
SQL> SELECT promo_id, promo_category
FROM promotions
WHERE promo_category = 'Internet' ORDER BY 2 DESC
UNION
SELECT promo_id, promo_category
FROM promotions
WHERE promo_category = 'TV'
UNION
SELECT promo_id, promo_category
Which statement is true regarding the outcome of the above query?
A. It executes successfully and displays rows in the descending order of PROMO_CATEGORY.
B. It produces an error because positional notation cannot be used in the ORDER BY clause with SET
operators.
C. It executes successfully but ignores the ORDER BY clause because it is not located at the end of the
compound statement.
D. It produces an error because the ORDER BY clause should appear only at the end of a compound
query-that is, with the last SELECT statement. ORDER BY必须要在句子最后
- OCP-1Z0-051-V9.02-155题
- 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题
- window安装mysql(zip、noinstall)
- 翻译数字串 transform number to string
- RTSP OPTION介绍
- Flyweight模式
- KGDB原理
- OCP-1Z0-051-V9.02-155题
- .htaccess:正则表达式、重定向代码
- 设置VisualSVN在提交修改时必须输入一定数量的备注信息
- aix 上安装oracle的文章
- Phonegap安裝筆記
- ajaxfileupload带多个参数上传方法
- android一种较为复杂的布局
- Android的电源管理
- MVC通俗演义系列开篇