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 vote198 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
1 vote175 views1 answer
Sql not equal multiple columns
SQL
0 vote177 views1 answer
Drop constraint in ms sql
SQL
3 votes204 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote245 views1 answer
Oracle current date minus 1 day
SQL
0 vote258 views1 answer
Jooq replace
SQL
7 votes179 views1 answer
Oracle set sequence value to max(id)
SQL
6 votes246 views3 answers
Mysql change auto_increment start value
SQL
0 vote184 views1 answer
Mysql create pool
SQL
3 votes185 views1 answer
Postgres count distinct
SQL