Paging with Oracle

by

Something like this should work: From Frans Bouma’s Blog 

SELECT * FROM
(
    SELECT a.*, rownum r__
    FROM
    (
        SELECT * FROM ORDERS WHERE CustomerID LIKE 'A%'
        ORDER BY OrderDate DESC, ShippingDate DESC
    ) a
    WHERE rownum < ((pageNumber * pageSize) + 1 )
)
WHERE r__ >= (((pageNumber-1) * pageSize) + 1)

More Related Contents:

  1. Call a stored procedure with another in Oracle
  2. Solution to “cannot perform a DML operation inside a query”?
  3. Array in IN() clause oracle PLSQL
  4. Inserting into Oracle and retrieving the generated sequence ID
  5. How do I call an Oracle stored procedure from an Excel VBA script?
  6. How to use Alias in Where clause? [duplicate]
  7. Local Temporary table in Oracle 10 (for the scope of Stored Procedure)
  8. PL SQL UPDATE STATEMENT
  9. Oracle SQL pivot query
  10. Return row with the max value of one column per group [duplicate]
  11. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  12. How to handle a single quote in Oracle SQL
  13. Select count(*) from multiple tables
  14. REGEX to select nth value from a list, allowing for nulls
  15. Concatenate and group multiple rows in Oracle [duplicate]
  16. Difference between BYTE and CHAR in column datatypes
  17. How do I execute a stored procedure once for each row returned by query?
  18. create table with sequence.nextval in oracle [duplicate]
  19. Which is better: Ad hoc queries or stored procedures? [closed]
  20. Group by alias (Oracle)
  21. Split comma separated values of a column in row, through Oracle SQL query
  22. Custom Date/Time formatting in SQL Server
  23. oracle — Split multiple comma separated values in oracle table to multiple rows
  24. Oracle : select maximum value from different columns of the same row
  25. Split varchar into separate columns in Oracle
  26. Creating or simulating two dimensional arrays in PL/SQL
  27. Search an Oracle database for tables with specific column names?
  28. How to replace specific values in a oracle database column?
  29. Query a Table’s Foreign Key relationships
  30. is there a PRODUCT function like there is a SUM function in Oracle SQL?

Leave a Comment