Maravillosa SQL para paginar resultados
Sencilla consulta SQL para paginar resultados para base de datos Oracle:
SELECT far_id, ROWNUM AS page_position, list_position FROM
(
SELECT articles.far_id, ROWNUM AS list_position FROM
(
SELECT far_id
FROM far
ORDER BY far_id
)
articles
)
WHERE list_position BETWEEN :min AND :max
