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

5 votes291 views2 answers
Oracle timestamp to date
SQL
0 vote319 views1 answer
Oracle NLS_CHARACTERSET
SQL
1 vote301 views1 answer
Continue in sql
SQL
0 vote285 views2 answers
Return the number of records in a single table mysql
SQL
2 votes298 views1 answer
Oracle convert run_duration to number
SQL
0 vote290 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
6 votes296 views1 answer
Wordpress change user password sql
SQL
0 vote288 views1 answer
Except in sql alchemy
SQL
0 vote306 views1 answer
On delete set default
SQL
0 vote309 views1 answer
How to delete python anywhere mysql database
SQL