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

4 votes167 views4 answers
What is primary key
SQL
1 vote153 views1 answer
Oracle lock user
SQL
24 votes186 views5 answers
List mysql users
SQL
0 vote188 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
10 votes140 views2 answers
Mysql select timestamp group by day
SQL
4 votes206 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote180 views1 answer
How to run mysql in git bash
SQL
0 vote200 views1 answer
Sql server create constraint
SQL
-1 vote124 views3 answers
Ubuntu install mssql
SQL
24 votes195 views6 answers
Alter table name sql
SQL