use rownum: select * from (select rownum rn,a.* from table)b where b.rn between 10000 and 10300
你应该有一个定位的标准,如果没有就采用:ROWID。 select * from table where rownum <= 300 and rowid >= (select max(rowid) from table where rownum <= 1000); 如果有排序则可以定位到排序的列,加条件即可。
select * from table where rownum < number1 minus select * from table where rownum < number2 ; the number1 must be larger than number1
select * from (select rownum rn,a.* from table)b
where b.rn between 10000 and 10300
select * from table where rownum <= 300 and rowid >= (select max(rowid) from table where rownum <= 1000);
如果有排序则可以定位到排序的列,加条件即可。
where rownum < number2 ;
the number1 must be larger than number1