|
|
|
|
|
|
Re: Adding rownum in pagination query in oralce 12c [message #671724 is a reply to message #671713] |
Sat, 15 September 2018 13:30 |
John Watson
Messages: 8951 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You doidn't even try, did you?pdby1> select e.*,rownum from (select * from emp order by job) e offset 7 rows fetch next 5 rows only;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ROWNUM
---------- ---------- --------- ---------- ------------------- ---------- ---------- ---------- ----------
7566 JONES MANAGER 7839 1981-04-02:00:00:00 2975 20 8
7782 CLARK MANAGER 7839 1981-06-09:00:00:00 2450 10 9
7839 KING PRESIDENT 1981-11-17:00:00:00 5000 10 10
7844 TURNER SALESMAN 7698 1981-09-08:00:00:00 1500 0 30 11
7654 MARTIN SALESMAN 7698 1981-09-28:00:00:00 1250 1400 30 12
pdby1>
|
|
|
|
|