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

7 votes174 views2 answers
3rd height salary sql
SQL
0 vote159 views2 answers
Mysql password error create datbase
SQL
0 vote165 views1 answer
Get all employees if name ends with in sql
SQL
1 vote160 views1 answer
Round function in sql oracle
SQL
27 votes187 views6 answers
Set password mysql
SQL
1 vote158 views1 answer
Login to database mysql terminal
SQL
3 votes229 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
1 vote176 views1 answer
Sql try catch
SQL
6 votes186 views3 answers
Date_trunc postgres
SQL
5 votes161 views1 answer
How to check nls timestamp format in oracle
SQL