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

0 vote233 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote195 views1 answer
Cast as decimal postgresql
SQL
0 vote249 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
0 vote256 views1 answer
Delete from table where length sql
SQL
40 votes278 views4 answers
PostgreSQL add column
SQL
0 vote254 views5 answers
Select concat alter table mysql
SQL
2 votes263 views2 answers
Mysql search for column name in all tables
SQL
0 vote259 views2 answers
How to truncate all table in mysql workbench
SQL
13 votes197 views4 answers
Mysql get last row
SQL
3 votes194 views2 answers
Mysql add 2 hours
SQL