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 vote107 views1 answer
Connect postgresql using a connection string
SQL
3 votes138 views1 answer
Mysql cli connect with password
SQL
0 vote107 views1 answer
Sql reverse order of results
SQL
0 vote103 views1 answer
Transaction and commit trong sql server
SQL
0 vote114 views1 answer
Compress sql file database ubuntu
SQL
0 vote104 views1 answer
SAP Return
SQL
22 votes113 views3 answers
Remove all records from table mysql
SQL
0 vote107 views2 answers
Get item by composite primary key mysql
SQL
1 vote132 views2 answers
How to add amount between date in sql
SQL
0 vote103 views1 answer
Sql select column names starting with
SQL