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 vote308 views1 answer
Mitigation of sql injection
SQL
8 votes355 views4 answers
Mysql update one table from another table multiple columns
SQL
0 vote338 views1 answer
Check index sql server
SQL
8 votes406 views1 answer
See all users mysql
SQL
0 vote383 views1 answer
Oracle list of long running queries
SQL
9 votes372 views5 answers
Laravel to sql
SQL
18 votes383 views3 answers
Mysql add column default value
SQL
4 votes447 views4 answers
Remove duplicate old value in mysql
SQL
0 vote396 views1 answer
How do you insert boolean to postgresql
SQL
0 vote323 views1 answer
Split a string with expression and get the last value of split sql
SQL