Oracle pagination query offset

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

2 votes150 views1 answer
Mysql select default if null
SQL
0 vote140 views1 answer
Oracle call a function in a insert statement
SQL
1 vote137 views1 answer
Sql server datetime vs datetime2
SQL
1 vote244 views1 answer
Mysql data from file
SQL
1 vote146 views1 answer
How to use db.execute
SQL
1 vote213 views1 answer
Python clean sql string
SQL
15 votes308 views2 answers
How to sort names in alphabetical order in sql
SQL
8 votes181 views4 answers
Convert date to dd/mm/yyyy sql
SQL
1 vote174 views2 answers
Login to mysql
SQL
2 votes171 views3 answers
How to replace null values in sql
SQL