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

1 vote107 views1 answer
Postgresql round double precision
SQL
0 vote123 views1 answer
Sql statement show all emails with dome
SQL
0 vote109 views1 answer
Mysql command prompt date insert format
SQL
1 vote123 views1 answer
Get parameter value in mysql trigger
SQL
0 vote123 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
0 vote111 views1 answer
Mysql date time string format for marshmellow field schema
SQL
4 votes123 views1 answer
Describe table mysql
SQL
0 vote121 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote66 views1 answer
Postgres delete where id in
SQL
0 vote107 views4 answers
Best data type to represent money in mysql
SQL