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 vote151 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote173 views1 answer
Get only structure database mysql
SQL
0 vote174 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
1 vote150 views1 answer
Sql group by error
SQL
3 votes146 views4 answers
Show sql server database
SQL
19 votes145 views5 answers
Date between in mysql
SQL
1 vote169 views1 answer
Mysql select for update ejemplo
SQL
8 votes150 views1 answer
Oracle add months to sysdate
SQL
0 vote160 views1 answer
How to find lowest in sql
SQL
5 votes145 views1 answer
How to get all dates in a month in oracle
SQL