Sql pagination oracle

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

0 vote132 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
6 votes157 views3 answers
Rename column ORACLE
SQL
0 vote143 views1 answer
Python connect to mysql in settings.py
SQL
0 vote108 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote116 views1 answer
Mysql find missing values
SQL
6 votes114 views2 answers
How to copy data in sql
SQL
14 votes128 views6 answers
Auto_increment mysql
SQL
0 vote132 views1 answer
Joins vs includes
SQL
13 votes122 views4 answers
Mysql get last row
SQL
1 vote133 views1 answer
Join to find results not in another table
SQL