1.select * from table_name where rownum minus
select * from table_name where rownum
2 .select * from (select t.*,rownum id from table_name t)
where id between n and n+m+1
1.select * from table_name where rownum minus
select * from table_name where rownum
2 .select * from (select t.*,rownum id from table_name t)
where id between n and n+m+1