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

0 vote184 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote291 views1 answer
Mysql grant access to one database
SQL
1 vote183 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote195 views1 answer
Postgres sequence name
SQL
0 vote187 views1 answer
Typeorm raw sql
SQL
15 votes187 views5 answers
If null mysql
SQL
1 vote185 views2 answers
Sql server add time to date
SQL
2 votes190 views1 answer
Oracle sql drop column if exists
SQL
3 votes185 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote178 views1 answer
Date diff sql
SQL