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 vote167 views1 answer
Shrink database file in sql server
SQL
8 votes140 views1 answer
Similarities between ddl and dml
SQL
0 vote186 views1 answer
Sql comand for removing data from table
SQL
1 vote229 views1 answer
How to get alternate records from a table in sql
SQL
1 vote190 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote204 views1 answer
Sql insert from excel
SQL
1 vote189 views1 answer
T-SQL Alter the column data type
SQL
5 votes197 views3 answers
Show indexes mysql
SQL
1 vote156 views1 answer
Mysql login console
SQL
0 vote222 views1 answer
What does the -p flag do in mysql cli
SQL