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 vote182 views1 answer
Mysql bash execute sql file
SQL
4 votes184 views2 answers
Mysql delete user if exists
SQL
1 vote174 views1 answer
Sql server datetime vs datetime2
SQL
3 votes179 views5 answers
Duplicate table sql
SQL
0 vote180 views1 answer
How do you insert boolean to postgresql
SQL
16 votes188 views3 answers
Jwt secret key generator laravel
SQL
0 vote205 views1 answer
Show all sequences postgres
SQL
5 votes168 views1 answer
Minecraft java port number
SQL
0 vote159 views1 answer
Min salary in sql
SQL
1 vote179 views1 answer
Postgresql reset serial counter after deleting content
SQL