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 vote222 views2 answers
Create table if not exist
SQL
1 vote208 views1 answer
Psql import backup file for windows
SQL
8 votes231 views4 answers
Reset SQL auto increment
SQL
0 vote196 views1 answer
Denormalise SQL command
SQL
0 vote204 views1 answer
Cast float mysql
SQL
4 votes195 views1 answer
Wildcard in sql
SQL
0 vote249 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote210 views2 answers
Postgresql get long running queries
SQL
16 votes262 views6 answers
Insert sql
SQL
0 vote201 views1 answer
Automatically update database last seen datetime in sql
SQL