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

1 vote358 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote289 views2 answers
Spring properties file for db
SQL
1 vote367 views1 answer
Floor function in sql oracle
SQL
4 votes356 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote323 views1 answer
Load utilities in sql server
SQL
-2 votes326 views1 answer
Mysql see users and passwords
SQL
0 vote327 views1 answer
Mysql return column names when table is empty
SQL
6 votes337 views1 answer
Postgres get size of database
SQL
39 votes383 views5 answers
Sql drop column
SQL
1 vote306 views1 answer
Mysql show current queries
SQL