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

15 votes211 views4 answers
Pl sql
SQL
4 votes283 views2 answers
Sql display today's date
SQL
0 vote223 views1 answer
Sql server express download
SQL
38 votes217 views4 answers
Count sql
SQL
2 votes222 views3 answers
Sql function
SQL
0 vote201 views1 answer
Full syntax inner join
SQL
0 vote206 views1 answer
Mysql group rows with same value
SQL
2 votes222 views1 answer
Postgresql left join distinct on
SQL
0 vote224 views1 answer
Sql select most frequent value in column
SQL
0 vote215 views1 answer
Call rest api from postgresql
SQL