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

1 vote196 views1 answer
Convert varchar to int in sqlite
SQL
0 vote196 views1 answer
Delete duplicate rows
SQL
5 votes192 views1 answer
Oracle nls session
SQL
0 vote167 views2 answers
Drop check constraint in ms sql
SQL
4 votes177 views1 answer
Sql data types
SQL
0 vote181 views7 answers
Les jointures sql server
SQL
3 votes189 views1 answer
Oracle rollback
SQL
0 vote204 views1 answer
Min:sec datediff mssql
SQL
0 vote232 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
0 vote197 views1 answer
Change redo log file size in mysql 5.6
SQL