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

2 votes131 views1 answer
Mysql application.properties spring boot
SQL
7 votes128 views2 answers
Html to react converter
SQL
0 vote128 views1 answer
Traccar mysql
SQL
0 vote128 views1 answer
Mysql count unique in group statement
SQL
13 votes133 views2 answers
Sql online compiler
SQL
0 vote128 views1 answer
Update one column from another column in same table
SQL
9 votes119 views2 answers
Mysql change value
SQL
21 votes122 views1 answer
SQL cheat sheet pdf
SQL
0 vote117 views1 answer
Get sum sqlite android
SQL
1 vote137 views5 answers
Sql 2nd highest salary
SQL