Sql pagination oracle

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 vote185 views1 answer
Qt qsql check if table exist
SQL
3 votes190 views2 answers
Order by postgresql
SQL
8 votes179 views1 answer
Oracle create datafile
SQL
0 vote192 views1 answer
Mod in sql
SQL
3 votes182 views2 answers
Oracle for loop
SQL
5 votes251 views2 answers
Add days in oracle sql
SQL
0 vote191 views1 answer
Hotw to alter lengh character vayng postgres
SQL
22 votes291 views4 answers
Tsql rename table
SQL
0 vote176 views1 answer
Update top 100 sql
SQL
0 vote253 views1 answer
How to get number of months between 2 dates sql server
SQL