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 vote156 views1 answer
Mysql remove bad character from all fields
SQL
1 vote150 views2 answers
Procedure syntax
SQL
0 vote157 views1 answer
Mysql utc timestamp
SQL
0 vote135 views1 answer
Mysql export and import
SQL
0 vote143 views1 answer
R write csv without index
SQL
2 votes124 views1 answer
Ifnull postgres
SQL
0 vote157 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote135 views1 answer
Mysql function variable
SQL
2 votes145 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote143 views1 answer
Drop-toys-table
SQL