Sql pagination oracle

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 votes391 views1 answer
Sql string starts with
SQL
0 vote362 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
0 vote345 views1 answer
How to get specific salary in sql
SQL
2 votes321 views1 answer
Mysql add boolean column
SQL
12 votes410 views6 answers
Change mysql root password
SQL
0 vote315 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
6 votes335 views2 answers
Join vs union
SQL
0 vote347 views2 answers
Oracle sql for each row
SQL
0 vote334 views1 answer
Sql server sleep
SQL
0 vote333 views1 answer
Sql datediff month
SQL