Alternatives to LIMIT and OFFSET for paging in Oracle
Posted
by depr001
on Stack Overflow
See other posts from Stack Overflow
or by depr001
Published on 2010-05-26T10:41:45Z
Indexed on
2010/05/26
10:51 UTC
Read the original article
Hit count: 200
Hello, I'm developing a web application and need to page ordered results. I normaly use LIMIT/OFFSET for this purpose.
Which is the best way to page ordered results in Oracle? I've seen some samples using rownum and subqueries. Is that the way? Could you give me a sample for translating this SQL to Oracle:
SELECT fieldA,fieldB
FROM table
ORDER BY fieldA
OFFSET 5 LIMIT 14
(I'm using Oracle 10g, for what it's worth)
Thanks!
© Stack Overflow or respective owner
