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 vote100 views1 answer
Acual month sql
SQL
1 vote121 views1 answer
UseSqlServer no definition
SQL
0 vote121 views1 answer
Sql cmd no truncate
SQL
0 vote112 views1 answer
Php get closest location by latitude longitude
SQL
0 vote114 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
3 votes104 views1 answer
Postgres count distinct
SQL
0 vote55 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote110 views1 answer
Sql find all different values in column
SQL
0 vote118 views1 answer
Sql delete caracter list
SQL
4 votes102 views1 answer
Sql query to make a existing column auto increment
SQL