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

31 votes112 views3 answers
Sql count(*)
SQL
0 vote158 views2 answers
Wordpress change url in database
SQL
5 votes113 views2 answers
Oracle tables with column name
SQL
1 vote103 views1 answer
Oracle add proxy
SQL
0 vote103 views2 answers
How to delete the rows with null values in mysql
SQL
27 votes124 views6 answers
Set password mysql
SQL
4 votes103 views1 answer
Sql any
SQL
3 votes116 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote109 views1 answer
Const pool = mysql.createpool()
SQL
0 vote103 views1 answer
Psql check if value in array
SQL