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

0 vote199 views1 answer
Sql change column in existing table
SQL
6 votes188 views2 answers
Oracle
SQL
1 vote191 views1 answer
Sql delete all values in a column
SQL
0 vote193 views2 answers
Start mysql server using docker
SQL
0 vote191 views1 answer
Mariadb errno 121
SQL
0 vote294 views1 answer
Store case result sql
SQL
0 vote406 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote179 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
1 vote209 views1 answer
Create new table from old table
SQL
0 vote187 views1 answer
Concatenate columns in table
SQL