Oracle pagination query offset

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

10 votes129 views4 answers
Inner join in update query mysql
SQL
1 vote136 views3 answers
SELECT * FROM
SQL
1 vote75 views1 answer
Database run
SQL
2 votes154 views1 answer
Oracle insert or update
SQL
10 votes124 views3 answers
Sql check double value
SQL
1 vote1.8K views1 answer
Dropping a constraint in ms sql
SQL
2 votes127 views1 answer
Use cases condition in sql query laravel
SQL
24 votes113 views4 answers
How to add column sql
SQL
0 vote127 views1 answer
Foreign key multiple columns
SQL
2 votes126 views1 answer
Postgresql format date dd/mm/yyyy
SQL