Sql pagination oracle

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 vote345 views1 answer
Set column width in sqlplus
SQL
0 vote302 views1 answer
Query for maximum salary
SQL
0 vote342 views1 answer
How to save data in database in mysql node
SQL
0 vote391 views1 answer
Change date format in oracle query
SQL
0 vote361 views1 answer
Get create sql of hibernqte entity
SQL
5 votes346 views2 answers
Update all rows mysql
SQL
2 votes377 views3 answers
Sql function
SQL
8 votes509 views4 answers
Convert date to dd/mm/yyyy sql
SQL
5 votes401 views4 answers
SQL Order of execution
SQL
0 vote357 views1 answer
Postgres statistics
SQL