Oracle pagination query offset

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 vote210 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote232 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
-1 vote220 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote249 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
4 votes230 views4 answers
Date less than in sql
SQL
6 votes280 views2 answers
How to get last element sql
SQL
6 votes232 views1 answer
Postgres get size of database
SQL
16 votes208 views3 answers
Order by sql query
SQL
1 vote221 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote240 views3 answers
How to run sql query
SQL