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 vote204 views1 answer
10000000000000000000 am to meters
SQL
0 vote229 views1 answer
Sql developer sql worksheet not showing
SQL
11 votes203 views1 answer
Creating tables in sql with python
SQL
8 votes196 views1 answer
Oracle search source code
SQL
0 vote150 views1 answer
How to get last client id sql
SQL
0 vote195 views1 answer
Update table sql multiple set
SQL
5 votes195 views1 answer
Ignore duplicate rows in sqlite
SQL
2 votes246 views3 answers
Sql server reseed identity column
SQL
0 vote215 views1 answer
Sql query to find duplicate email address
SQL
0 vote203 views1 answer
Sqlalchemy one column of two has to be not null
SQL