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

1 vote138 views1 answer
How to get the date diff on once field in sql server
SQL
9 votes159 views3 answers
Import DB through mysql console
SQL
2 votes132 views2 answers
Oracle create table if not exists
SQL
1 vote136 views1 answer
Mysql select month and year
SQL
8 votes155 views1 answer
Check mysql version phpmyadmin
SQL
10 votes222 views2 answers
Doublon sql
SQL
12 votes136 views4 answers
Mysql ifnull
SQL
0 vote144 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
0 vote134 views1 answer
Mssql current date
SQL
4 votes247 views1 answer
What are the data types
SQL