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 vote105 views1 answer
Query on date sqlite flutter
SQL
0 vote163 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
13 votes125 views2 answers
Sql online compiler
SQL
0 vote71 views1 answer
Java spring boot connect to sql server
SQL
1 vote119 views1 answer
Show structure of table in sql
SQL
0 vote146 views1 answer
Sql server phone constraint
SQL
28 votes113 views4 answers
Delete database mysql
SQL
11 votes104 views2 answers
Sql rank
SQL
1 vote119 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
2 votes110 views2 answers
Mysql get time from datetime
SQL