Sql pagination oracle

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

17 votes150 views6 answers
Get last record in sql
SQL
0 vote117 views1 answer
Mysql regex exact match
SQL
0 vote134 views1 answer
Mysql milliseconds
SQL
15 votes212 views3 answers
Postgresql change column type
SQL
0 vote129 views1 answer
Get foreign table names mysql
SQL
3 votes123 views2 answers
Oracle apex charging debug
SQL
0 vote86 views1 answer
Mysql date + 1 day
SQL
8 votes172 views2 answers
Default sql server port
SQL
1 vote133 views1 answer
Postgresql escape single quote
SQL
6 votes123 views2 answers
Mysql concatenate two columns into one
SQL