Alternatives to LIMIT and OFFSET for paging in Oracle [duplicate] Alternatives to LIMIT and OFFSET for paging in Oracle [duplicate] oracle oracle

Alternatives to LIMIT and OFFSET for paging in Oracle [duplicate]


sql oracle sql-limit

As of oracle 12c, you could use the top N queries.

SELECT fieldA,fieldB FROM table ORDER BY fieldA OFFSET 5 ROWS FETCH NEXT 14 ROWS ONLY;

http://www.oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1.php

sql oracle sql-limit

Since you're on 10g, you should be able to simplify the ROWNUM approach using analytic functions

SELECT fieldA,        fieldB  FROM (SELECT fieldA,               fieldB,               row_number() over (order by fieldA) rnk          FROM table_name) WHERE rnk BETWEEN 5 AND 14;

sql oracle sql-limit

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last