Oracle pagination query rownum

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 vote201 views1 answer
How to fetch data from database in sql
SQL
4 votes202 views1 answer
Ms sql truncate table vs delete
SQL
1 vote175 views1 answer
Oracle apex prevent initial load
SQL
0 vote187 views1 answer
Disable database droping sql
SQL
1 vote164 views1 answer
Sql server select rows by distinct column
SQL
0 vote177 views1 answer
Postgresql print sessions using the database
SQL
8 votes185 views1 answer
Oracle search stored procedures for text
SQL
0 vote182 views1 answer
Create bdd mysql
SQL
0 vote177 views1 answer
Mysql 8 geo to json
SQL
9 votes200 views4 answers
SQL Date Format
SQL