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 vote160 views1 answer
Sql random sampling per group
SQL
0 vote134 views1 answer
Create date sql
SQL
0 vote184 views1 answer
Psql create usr
SQL
0 vote136 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
6 votes160 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote151 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote345 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote152 views1 answer
Sqlalchemy get ids
SQL
1 vote200 views1 answer
Show databases mysql docker
SQL
1 vote171 views1 answer
Top 10 rows in mysql
SQL