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

0 vote168 views1 answer
Unique element in sql
SQL
0 vote114 views1 answer
Import csv to mysql
SQL
7 votes142 views3 answers
Sql update where id
SQL
0 vote149 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote144 views1 answer
Show function mysql
SQL
1 vote171 views1 answer
Oracle apex version view
SQL
2 votes107 views1 answer
Foreign key example in dbms
SQL
0 vote166 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
2 votes138 views2 answers
Spring import sql
SQL
0 vote137 views1 answer
Mysql earlier than date
SQL