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

2 votes141 views3 answers
Copy data from one table column to another table column in sql
SQL
1 vote152 views1 answer
Opensuse restart MySQL
SQL
5 votes153 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote141 views4 answers
Change schema in sql server
SQL
1 vote147 views1 answer
Mysql order by desc null last
SQL
2 votes135 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
3 votes93 views1 answer
System.debug apex
SQL
0 vote140 views1 answer
How to add timestamp column in mysql
SQL
1 vote134 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
2 votes142 views1 answer
SQL column name Postgre
SQL