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 vote150 views1 answer
How to find unique key in sql
SQL
0 vote202 views1 answer
Change date in pivot table to month in sql server
SQL
7 votes167 views2 answers
Html to react converter
SQL
0 vote159 views2 answers
Raise notice in postgresql function
SQL
1 vote167 views1 answer
Postgresql substring last
SQL
2 votes276 views1 answer
Postgresql group by month and year
SQL
0 vote172 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
4 votes179 views1 answer
Oracle user tables
SQL
5 votes184 views3 answers
String concatenation sql server
SQL
0 vote178 views1 answer
Primary key multiple
SQL