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

3 votes242 views2 answers
Mysql add 2 hours
SQL
7 votes253 views1 answer
Safe update mysql
SQL
4 votes250 views4 answers
Update select mysql
SQL
0 vote264 views1 answer
Pl/ sql change currency
SQL
0 vote264 views1 answer
Edit a field mysql terminal
SQL
0 vote254 views1 answer
What is default mysql database password in linux
SQL
0 vote274 views1 answer
Time data type in mysql
SQL
0 vote260 views1 answer
Sql server system messeges
SQL
0 vote280 views1 answer
Mysql get hour from datetime
SQL
1 vote247 views1 answer
Delete row mssql
SQL