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

12 votes312 views5 answers
Sql merge
SQL
0 vote358 views1 answer
Create table using the clause with as
SQL
1 vote320 views3 answers
SELECT * FROM
SQL
11 votes310 views2 answers
Having in sql
SQL
14 votes317 views3 answers
Oracle sql limit results
SQL
0 vote344 views1 answer
Contraint default SQL
SQL
10 votes309 views1 answer
Query to find object dependencies in oracle
SQL
0 vote316 views1 answer
Sql create text column limited values
SQL
1 vote327 views1 answer
Mysql show attributes of a table
SQL
0 vote282 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL