Oracle pagination query rownum

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 vote263 views1 answer
Sql query for getting data with join and count
SQL
0 vote292 views1 answer
Store case result sql
SQL
0 vote281 views1 answer
SQL Query to delete all the tables in a database
SQL
16 votes277 views3 answers
Delete row psql
SQL
0 vote269 views1 answer
IS THEre any difference between using default and := in plsql
SQL
3 votes301 views1 answer
Create a table with an id in mysql
SQL
19 votes276 views2 answers
Mysql add column after another
SQL
0 vote263 views1 answer
Mysql group by derived column
SQL
1 vote267 views1 answer
Mysql pretty date format
SQL
0 vote260 views1 answer
Oracle right characters
SQL