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 vote183 views1 answer
Normalization in database
SQL
0 vote167 views1 answer
Including parameters in OPENQUERY
SQL
0 vote174 views1 answer
Gcloud check sql
SQL
0 vote164 views1 answer
Export partttion and import in oracle
SQL
0 vote184 views1 answer
Where date major today mysql
SQL
0 vote188 views1 answer
Sql dmv to capture updates
SQL
0 vote179 views1 answer
Convert polygon to text in mysql
SQL
4 votes182 views1 answer
W3schools create table
SQL
1 vote181 views1 answer
Database Queries
SQL
0 vote170 views1 answer
Mysql cast null to string
SQL