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 vote237 views1 answer
Sql string function update replace
SQL
0 vote220 views1 answer
Oracle last connection
SQL
1 vote269 views2 answers
Install sql server management studio ubuntu
SQL
0 vote227 views1 answer
Mysql count by month
SQL
0 vote225 views2 answers
Soql last year
SQL
19 votes255 views5 answers
Display table in sql
SQL
0 vote232 views1 answer
Mysql 8 error on identified by
SQL
0 vote229 views1 answer
C# check if mysql query modified rows
SQL
0 vote224 views1 answer
How to output a different column name in mysql
SQL
3 votes244 views1 answer
Sql print all names that start with a given letter
SQL