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 vote169 views1 answer
How to between in sql
SQL
0 vote202 views1 answer
To Create directory
SQL
2 votes183 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote165 views1 answer
Duplicate foreign key constraint name
SQL
3 votes218 views1 answer
Set default today mysql
SQL
4 votes205 views3 answers
NOT NULL SQL
SQL
2 votes179 views1 answer
Sql update from different table
SQL
0 vote178 views1 answer
Mysql match in serialized data
SQL
3 votes180 views2 answers
Oracle apex charging debug
SQL
11 votes187 views3 answers
How to get last row of table in sql
SQL