SQL> break on deptno skip 1
SQL> select deptno,ename,sal from emp order by deptno,sal desc;
---------- ---------- ----------
14 rows selected.
会有人问了,我想把空行去了怎么办,我想你懂得,把1换成0就好了吗!
SQL> break on deptno skip 0
SQL> select deptno,ename,sal,row_number() over(partition by deptno order by sal desc) drn from emp;
---------- --------------- ---------- ----------
14 rows selected.