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 vote353 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote340 views1 answer
Less than date query sqlachemy
SQL
0 vote330 views2 answers
How to update the multiple rows in sql
SQL
0 vote324 views1 answer
Update if else mysql
SQL
3 votes371 views2 answers
How to force truncate a table in mysql
SQL
1 vote379 views1 answer
Show databases mysql docker
SQL
57 votes574 views5 answers
How to create a new user in postgresql
SQL
0 vote372 views1 answer
How to install sql in anaconda
SQL
0 vote364 views1 answer
Insert into table with only identity column
SQL
0 vote342 views1 answer
Oracle archivelog usage
SQL