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 vote138 views1 answer
What is database username and password in mysqliconnect
SQL
1 vote126 views1 answer
Select if then postgresql
SQL
0 vote122 views1 answer
View acl table oracle
SQL
4 votes122 views2 answers
Mysql delete user if exists
SQL
1 vote140 views1 answer
Difference between where and having clause
SQL
27 votes130 views4 answers
Get all tables with column name sql
SQL
4 votes131 views2 answers
Show all database inside postgresql
SQL
0 vote122 views1 answer
Myswql show full processlist
SQL
7 votes98 views1 answer
Alter table add key sql
SQL
0 vote158 views1 answer
How to pass list as parameter in SQL query
SQL