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 vote416 views1 answer
Sql query for login with email or username
SQL
0 vote344 views1 answer
Find all tables where column name exists oracle
SQL
2 votes334 views1 answer
Match in sql server
SQL
0 vote357 views1 answer
Sql server convert to guid
SQL
19 votes344 views2 answers
Mysql add column after another
SQL
6 votes325 views2 answers
Spring data jpa application.properties mysql
SQL
2 votes359 views1 answer
Sql to char function with date
SQL
0 vote372 views1 answer
Default order by in mysql
SQL
1 vote353 views1 answer
Select if then postgresql
SQL
0 vote349 views1 answer
Sql waitfor
SQL