67.Which two statements are true regarding the ORDER BY clause? (Choose two.)
来源:互联网 发布:知乎 win10 杀毒软件 编辑:程序博客网 时间:2024/05/18 02:19
67.Which two statements are true regarding the ORDER BY clause? (Choose two.)
A.It is executed first in the query execution.
B.It must be the last clause in the SELECT statement.
C.It cannot be used in a SELECT statement containin g a HAVING clause.
D.You cannot specify a column name followed by an expression in this clause.
E.You can specify a combination of numeric positions and column names in this clause.
答案:BE
解析:order by 最后执行,第一个执行的应该是from,A错误,
SQL> select 1 from dual group by 1 having count(1)>0 order by 1;
1
----------
1
所以C错误,
D选项不知道他说啥,好像是说order 中不能是表达式
SQL> select * from dept order by 2*deptno;
DEPTNO DNAME LOC
---------- ---------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
70 D70 L70
所以D错误
B说的是order by在sql的最后
E说的是可以指定位置排序
A.It is executed first in the query execution.
B.It must be the last clause in the SELECT statement.
C.It cannot be used in a SELECT statement containin g a HAVING clause.
D.You cannot specify a column name followed by an expression in this clause.
E.You can specify a combination of numeric positions and column names in this clause.
答案:BE
解析:order by 最后执行,第一个执行的应该是from,A错误,
SQL> select 1 from dual group by 1 having count(1)>0 order by 1;
1
----------
1
所以C错误,
D选项不知道他说啥,好像是说order 中不能是表达式
SQL> select * from dept order by 2*deptno;
DEPTNO DNAME LOC
---------- ---------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
70 D70 L70
所以D错误
B说的是order by在sql的最后
E说的是可以指定位置排序
0 0
- 67.Which two statements are true regarding the ORDER BY clause? (Choose two.)
- 121.Which two statements are true regarding the USING clause in table joins? (Choose two .)
- 35.Which two statements are true regarding constraints? (Choose two.)
- 38.Which two statements are true regarding views? (Choose two.)
- 41.Which two statements are true regarding views? (Choose two.)
- 48.Which two statements are true regarding indexes? (Choose two.)
- 133.Which two statements are true regarding subqueries? (Choose two.)
- 175.Which two statements are true regarding savepoints? (Choose two.)
- 130.Which two statements are true regarding listeners? (Choose two.)
- 98.Which two statements are true regarding the usage of the SQL*Loader utility? (Choose two.)
- 108.Which two statements are true regarding the COUNT function? (Choose two.)
- 170.Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)
- 7.Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
- 4.Which two statements are true regarding single row functions? (Choose two.)
- 80.Which two statements are true regarding working with dates? (Choose two.)
- 26.Which two statements are true regarding undo tablespaces? (Choose two.)
- 27.Which two statements are true regarding transactions in an Oracle database? (Choose two.)
- 99.Which two statements are true regarding Oracle Data Pump? (Choose two.)
- Java读取properties配置文件中文乱码解决方案--谷营中西科技软件园---zdd
- RGB颜色查询对照表
- pymysql
- 卡马克:用C++进行函数式编程
- 安装Genymotion出现的错误
- 67.Which two statements are true regarding the ORDER BY clause? (Choose two.)
- Xamarin.Android使用教程之在Android和Xamarin Android Visual Designer中布局
- LeetCode Insertion Sort List
- Go语言发展状况和前景
- 浅谈C++数组与指针(一维)
- 算法 - 排序
- 【实例解析】某水泥企业应用商业智能提升管理效率
- Nagios中常见参数的含义
- IOS开发学习之自定义XIB的使用