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 vote254 views1 answer
Value of sold product using having and group by in sql
SQL
9 votes282 views3 answers
Date format in sql
SQL
0 vote275 views1 answer
Apt install sql server
SQL
-1 vote241 views2 answers
How to display top 50 rows?
SQL
7 votes260 views6 answers
Reset identity column in sql server
SQL
0 vote263 views1 answer
Function sum(text) does not exist postgres
SQL
3 votes261 views1 answer
Stpop start psql server
SQL
9 votes243 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
1 vote289 views1 answer
Oracle columns table
SQL
3 votes242 views1 answer
Sql select all
SQL