Imagine a list of blog entries, ordered by time, displaying the latest on top. This list is easily created by a VIEW:
Now lets load the data for the 11th page, where each page should list 25 blog entry titles:
ROW_NUMBER() OVER(order by date,time desc) as ROWNO,
first 500 rows only;
This should do the trick.
rowno > 25 * (11 - 1)
first 25 rows only ;