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 vote182 views1 answer
How to change the field size of an existing column
SQL
3 votes154 views2 answers
Mysql HAVING
SQL
1 vote195 views1 answer
Oracle columns table
SQL
0 vote139 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote209 views1 answer
Varchar2 length in oracle
SQL
-1 vote164 views2 answers
Installing mysql on centos 7
SQL
0 vote150 views1 answer
Get who is hired in january in sql
SQL
0 vote170 views2 answers
Jsonb
SQL
0 vote147 views2 answers
Start mysql server using docker
SQL
6 votes1.7K views1 answer
Sql select second max
SQL