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 vote715 views2 answers
Zsh: command not found: mysq
SQL
4 votes271 views1 answer
Sql any
SQL
1 vote323 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote275 views1 answer
Test the postgresql db connection
SQL
0 vote255 views2 answers
Mysql get routine parameter list
SQL
0 vote278 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote273 views2 answers
Get top 1 row of each group
SQL
0 vote277 views1 answer
Postgres create extension if not exists
SQL
7 votes287 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
1 vote272 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL