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

6 votes285 views2 answers
Mysqldump password in file
SQL
0 vote280 views1 answer
Watch mysql command line
SQL
38 votes266 views4 answers
Count sql
SQL
2 votes258 views1 answer
Drop table purge
SQL
-1 vote280 views1 answer
Sql show custom constraints
SQL
17 votes276 views6 answers
What is cursor in sql server with example
SQL
0 vote279 views1 answer
How to start my sql server on mac
SQL
0 vote258 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote266 views1 answer
Sql server system messeges
SQL
1 vote281 views1 answer
How to put value in variable mysql
SQL