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

by

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

More Related Contents:

  1. How do I limit the number of rows returned by an Oracle query after ordering?
  2. How do I do top 1 in Oracle? [duplicate]
  3. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  4. Receive an unexpected symbol error in my PLSQL query [closed]
  5. SQL Query to concatenate column values from multiple rows in Oracle
  6. Search All Fields In All Tables For A Specific Value (Oracle)
  7. Oracle: how to UPSERT (update or insert into a table?)
  8. Get top results for each group (in Oracle)
  9. Paging with Oracle
  10. Oracle Differences between NVL and Coalesce
  11. ORA-12560: TNS:protocol adaptor error
  12. SQL – How to store and navigate hierarchies?
  13. How do you create a temporary table in an Oracle database?
  14. What exactly do quotation marks around the table name do?
  15. Calculating difference between two timestamps in Oracle in milliseconds
  16. How can I get column names from a table in Oracle?
  17. How to store only time; not date and time?
  18. How does GROUP BY work?
  19. How can I find which tables reference a given table in Oracle SQL Developer?
  20. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  21. Oracle equivalent of Postgres’ DISTINCT ON?
  22. INSERT SELECT statement in Oracle 11G
  23. Display names of all constraints for a table in Oracle SQL
  24. SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
  25. `show create table` equivalent in oracle sql
  26. Does ‘Select’ always order by primary key?
  27. How to use a dynamic parameter in a IN clause of a JPA named query?
  28. Oracle DB: How can I write query ignoring case?
  29. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
  30. Oracle Convert TIMESTAMP with Timezone to DATE

Leave a Comment