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 vote301 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
3 votes322 views2 answers
To_char sql
SQL
1 vote316 views1 answer
Sqlalchemy order_by
SQL
0 vote311 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote289 views1 answer
Update top 100 sql
SQL
0 vote309 views1 answer
Oracle shrink table
SQL
1 vote308 views1 answer
Sql how to duplicate a table
SQL
0 vote316 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
65 votes521 views6 answers
Sql add column to table
SQL
1 vote295 views1 answer
Sql exclude duplicates and find even id
SQL