break on deptno skip 1
来源:互联网 发布:mysql异地容灾方案 编辑:程序博客网 时间:2024/05/16 18:04
SQL> break on deptno skip1
SQL> select deptno,ename,sal from emp order bydeptno,sal desc;
---------- ---------- ----------
14 rows selected.
会有人问了,我想把空行去了怎么办,我想你懂得,把1换成0就好了吗!
SQL> break on deptno skip0
SQL> select deptno,ename,sal,row_number()over(partition by deptno order by sal desc) drn from emp;
---------- --------------- ---------- ----------
14 rows selected.
- break on deptno skip 1
-  
-
- ruby on Httpwatch 脚本
- INSERT ... ON DUP…
- Join语句的on 与 select xxx in…
- Go, on Android
- ZZULI_SummerPractice(3) HDU 1…
- HDOJ 4311 Meeting point-1
- [QTP] Interview questions on Qui…
- Device drivers on SMP systems
- Device drivers on SMP systems
- Prostitute boycotts Chinese on e…
- Error ORA-19606 on RMAN Delete
- How to Perform a Healthcheck on …
- The City Built on Steep Hills --…
- js quality and so on ......
- IIS7.5 An error occurred on the …
- oracle10.2.0.1.0升级到10.2.0.4.0
- CentOS(RedHat)中sendmail启动慢解决方法
- lvm(逻辑卷管理)
- nagios下的rrdtool导库
- linux下10goracle datagard(stand…
- break on deptno skip 1
- samba共享
- linux中的特殊权限s\t
- windows下的运行命令大全
- 感悟1
- 感悟2
- 感悟3
- 感悟4
- linux下的openvpn搭建