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 vote281 views1 answer
Where field is null sql knex
SQL
0 vote279 views1 answer
What is the difference between now() and current_date()?
SQL
1 vote298 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote279 views1 answer
Restart sql server command line linux
SQL
0 vote264 views1 answer
Mysql into outfile with headers
SQL
0 vote271 views1 answer
Mysql show create db
SQL
0 vote297 views1 answer
Exit psql
SQL
1 vote266 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote271 views1 answer
Get first monday of month sql
SQL
13 votes293 views3 answers
Insert mysql ifile nto database
SQL