Sql pagination oracle

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 vote291 views2 answers
Change database postgres
SQL
0 vote308 views1 answer
Sql #region
SQL
0 vote350 views1 answer
Delete hangfire retries list
SQL
3 votes310 views2 answers
Oracle drop column
SQL
27 votes312 views6 answers
Set password mysql
SQL
1 vote300 views1 answer
Add current timestamp in mysql
SQL
0 vote314 views1 answer
Alter rename command in mysql
SQL
3 votes318 views1 answer
Postgres kill running query
SQL
0 vote294 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote309 views1 answer
Drop constraint in ms sql
SQL