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 vote264 views1 answer
Oracle explain plan
SQL
7 votes284 views3 answers
How ot change name of column mysql
SQL
0 vote292 views1 answer
Show tables in cassandra cql
SQL
0 vote251 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
6 votes288 views2 answers
Difference between join vs union
SQL
0 vote303 views2 answers
Temp tables in sql server
SQL
17 votes326 views1 answer
Selecting name that contain certain word in sql
SQL
1 vote301 views2 answers
Truncate table sqlite
SQL
16 votes271 views3 answers
Delete row psql
SQL
-1 vote283 views1 answer
Round up and down sql
SQL