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 vote134 views2 answers
How to tun mysql on ubunto
SQL
0 vote248 views1 answer
Sql server query all database objects
SQL
0 vote130 views1 answer
How to count null values in sql
SQL
1 vote133 views1 answer
Database Queries
SQL
0 vote127 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote134 views1 answer
How to list function in psql
SQL
0 vote134 views1 answer
Sql find leading space
SQL
27 votes151 views6 answers
Sql update record
SQL
-2 votes144 views1 answer
Create trigger syntax
SQL
0 vote132 views1 answer
Sql server get date of previous sunday
SQL