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 vote103 views1 answer
Char varchar nvarchar sql
SQL
0 vote107 views1 answer
Oracle session statistics
SQL
11 votes106 views2 answers
Oracle source code
SQL
0 vote113 views1 answer
Get relation data in mysql using query to excel
SQL
1 vote119 views1 answer
Ubuntu access database from terminal
SQL
0 vote94 views1 answer
Mysql change default collation
SQL
18 votes128 views2 answers
Sql comments
SQL
0 vote104 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote94 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote111 views1 answer
Resullt all update knex mysql
SQL