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

1 vote371 views1 answer
Write a query to create an empty table from an existing table?
SQL
5 votes369 views1 answer
Get table columns from sql
SQL
0 vote360 views2 answers
Wordpress change url in database
SQL
0 vote375 views1 answer
C# get sql min date
SQL
0 vote380 views1 answer
Plsql find location of procedure
SQL
0 vote364 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote302 views1 answer
Check if has alpha characters sql
SQL
1 vote373 views1 answer
Generate random data postgresql
SQL
3 votes375 views4 answers
Order by desc postgres
SQL
2 votes379 views3 answers
Postgres create view
SQL