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

9 votes227 views2 answers
Oracle all tables in schema
SQL
58 votes566 views6 answers
Create new user in postgres
SQL
0 vote210 views1 answer
Utiliser sql ligne de commande
SQL
0 vote165 views1 answer
Como leer datos de mysql esp32
SQL
0 vote201 views1 answer
Alter table engine mysql
SQL
0 vote213 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote207 views1 answer
Generate sequence number in sql server
SQL
1 vote187 views1 answer
Sql delete row with auto increment
SQL
2 votes198 views1 answer
Get first 2 letter in sql
SQL
0 vote244 views1 answer
Postgres execute multiple sql file from command line
SQL