Oracle pagination query rownum

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 vote168 views3 answers
Mysql on delete set null
SQL
0 vote171 views3 answers
Join
SQL
0 vote180 views1 answer
Mysql multiple group by
SQL
1 vote151 views1 answer
Postgres concat_ws
SQL
1 vote145 views2 answers
DROP TABLes regardless of constraints
SQL
2 votes148 views1 answer
Mysql add boolean column
SQL
0 vote154 views3 answers
Group_concat sql server
SQL
16 votes171 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
3 votes133 views1 answer
MySQL DELETE JOIN
SQL
0 vote140 views1 answer
Json not contains mysql
SQL