for example,if you want to have records from 10 to 20
do
select * from emp where rownum < 21
minus
select * from emp where rownum < 11;
Dragon
|
Results 1 to 7 of 7
Thread: How to get 20rows at a time?Threaded View
|
Click Here to Expand Forum to Full Width |