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

1 vote162 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote146 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote151 views1 answer
Drop column from table if exist on live server mysql
SQL
8 votes140 views1 answer
Oracle current date plus 1 month
SQL
0 vote135 views1 answer
Add multiple field in table sql
SQL
1 vote140 views2 answers
Sql where keyword
SQL
3 votes149 views1 answer
Select sequence oracle
SQL
0 vote145 views1 answer
T sql check active deadlock
SQL
0 vote146 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote140 views1 answer
Psql list view rules
SQL