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 vote209 views1 answer
Query to get all primary keys and foreign key
SQL
4 votes213 views1 answer
T-sql get duplicate rows
SQL
9 votes232 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote201 views1 answer
Oracle activate program
SQL
2 votes218 views2 answers
Select list is not in group by clause
SQL
10 votes238 views2 answers
Doublon sql
SQL
2 votes246 views2 answers
Mysql does sentence contain word
SQL
0 vote247 views1 answer
Creating h2 database in relative directory eclopse
SQL
24 votes236 views5 answers
List mysql users
SQL
0 vote208 views1 answer
Sql server whoami
SQL