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 vote244 views1 answer
Oracle sql first day of year
SQL
0 vote243 views2 answers
Create-toys-table-with-toy_name-column
SQL
2 votes240 views1 answer
Columns Present in a table
SQL
1 vote246 views2 answers
One to one and one to many relationship
SQL
3 votes233 views3 answers
How to add month in update sql
SQL
5 votes249 views2 answers
Create function postgresql
SQL
9 votes254 views3 answers
Import DB through mysql console
SQL
12 votes237 views6 answers
Between in sql
SQL
11 votes250 views3 answers
How to get last row of table in sql
SQL
1 vote237 views1 answer
Last 6 months postgresql
SQL