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

0 vote277 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote287 views1 answer
Turnicate in mysql
SQL
0 vote293 views1 answer
Create new schema mysql
SQL
0 vote285 views2 answers
Get all index postgres
SQL
0 vote287 views1 answer
How to check even or odd in sql
SQL
0 vote272 views1 answer
T sql return on letters only
SQL
0 vote296 views1 answer
Access mysql database docker container shell
SQL
5 votes292 views1 answer
Oracle generate list of dates in between a date range
SQL
6 votes296 views5 answers
Sql add months to date
SQL
1 vote281 views1 answer
Column with prefix in sql
SQL