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

3 votes340 views2 answers
Tsql join multiple record in one string
SQL
0 vote409 views1 answer
Sqlite display headers on columns
SQL
10 votes344 views2 answers
Oracle alter sequence nextval
SQL
2 votes332 views1 answer
Query any digits record
SQL
0 vote342 views1 answer
Update sql sintax
SQL
1 vote335 views1 answer
Oracle create_program
SQL
11 votes353 views5 answers
Laravel db facade
SQL
0 vote286 views1 answer
Plsql trigger insert update
SQL
0 vote358 views1 answer
Date 3 months from today sql
SQL
0 vote359 views1 answer
Bitmap join index
SQL