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

1 vote199 views1 answer
Table information in sql server
SQL
1 vote197 views2 answers
Sql for date greater than
SQL
1 vote193 views1 answer
Funzioni plsql
SQL
7 votes294 views2 answers
Oracle foreign key reference table
SQL
1 vote209 views2 answers
Regex starts with
SQL
0 vote200 views1 answer
Postgres drop type
SQL
3 votes288 views6 answers
Jwt laravel
SQL
3 votes204 views1 answer
Sql is not like
SQL
1 vote261 views1 answer
Sql in array query
SQL
0 vote240 views1 answer
Remove mysql from centos 7
SQL