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 vote146 views1 answer
Ms Sql set us timezone
SQL
0 vote151 views1 answer
Copy Table from SQL to CSV
SQL
17 votes161 views2 answers
T_sql contains
SQL
0 vote169 views1 answer
Django mssql backend
SQL
12 votes182 views1 answer
Create column sql server
SQL
6 votes206 views3 answers
Mysql change auto_increment start value
SQL
0 vote157 views1 answer
Oracle array
SQL
4 votes172 views2 answers
Tables in sql
SQL
0 vote148 views1 answer
Transaction database with php
SQL
2 votes161 views2 answers
Insert all in sql
SQL