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

0 vote161 views1 answer
Mysql order by where condition sub query
SQL
1 vote149 views1 answer
How to group by month using sql server
SQL
2 votes156 views1 answer
Sql percentage with % rounded down
SQL
0 vote141 views1 answer
Turn on foreign keys check mysql
SQL
2 votes128 views1 answer
Create table with primary key
SQL
0 vote225 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
57 votes329 views6 answers
Sql alter table
SQL
1 vote139 views3 answers
How to get date in sql
SQL
0 vote170 views1 answer
Import sql inside hide sql
SQL
0 vote128 views1 answer
Clear query cache sql server
SQL