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 vote410 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote347 views2 answers
Sql searching via key word
SQL
0 vote356 views1 answer
Helptext in sql
SQL
0 vote343 views1 answer
Sql delete where x or y or z
SQL
0 vote347 views2 answers
Identity column in sql server
SQL
7 votes365 views1 answer
Oracle alter sequence restart start with
SQL
0 vote386 views1 answer
SQL server datetime compare
SQL
2 votes324 views1 answer
Sqlite show table indexes
SQL
0 vote364 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote340 views1 answer
Google cloud sql postgres url example
SQL