Oracle pagination query rownum

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

Source: stackoverflow.com

Similar codes

4 votes141 views4 answers
Check constraint in ms sql
SQL
0 vote143 views1 answer
Oracle last connexion
SQL
0 vote133 views1 answer
Sql server update top n records
SQL
0 vote135 views1 answer
How much table store postgres
SQL
2 votes142 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote144 views1 answer
Make parameters nullable in sql server
SQL
-1 vote142 views4 answers
Restart mysql server ubuntu
SQL
0 vote132 views1 answer
Intellij mysql set timezone
SQL
0 vote220 views1 answer
Run mysql xampp shell
SQL
1 vote323 views1 answer
Foreign key in oracle sql developer
SQL