HuyPV
Wednesday, September 1, 2010
SELECT * FROM
(SELECT field, rownum rn FROM table)
WHERE rn > [offset] AND rownum <= [limit];
Title:
Oracle SQL Pagination limit offset
Description:
SELECT * FROM (SELECT field, rownum rn FROM table) WHERE rn > [offset] AND rownum <= [limit];
...
Rating:
4