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

8 votes125 views1 answer
Database backup in mysql server recovery
SQL
0 vote140 views2 answers
Select last 30 days sql
SQL
1 vote117 views1 answer
Adding a check statement in sql
SQL
6 votes125 views2 answers
Mysql check auto increment value
SQL
1 vote117 views1 answer
Floor function in sql oracle
SQL
2 votes121 views4 answers
List databases in sql server
SQL
0 vote129 views1 answer
Stored procedure function relation
SQL
1 vote120 views1 answer
Group_concat order by
SQL
-1 vote130 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote128 views1 answer
Sql sum if
SQL