Paging in Oracle is not as easy as one could think.
If you would like your query to return lets say 100 rows with the start at row 1300:
select * from (
select rowum as rn, b.*
from (select a.columnName1, a.columnName2
from tableName a
order by a.columnName1) b
) c
where c.rn between 1300 and 1300 + 100
No comments:
Post a Comment