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

0 vote201 views1 answer
Sql cheetsheet
SQL
1 vote200 views1 answer
Show per page table in xampp
SQL
0 vote192 views1 answer
Sql from null to not null
SQL
2 votes220 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote203 views1 answer
Console output pl sql
SQL
3 votes193 views4 answers
Mysql delete duplicate rows
SQL
-1 vote223 views1 answer
Phinehas Psalm 106
SQL
0 vote200 views1 answer
Sql replace id with name from another table
SQL
0 vote238 views1 answer
Get substract count sql
SQL
14 votes205 views2 answers
Oracle add column with default value
SQL