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 vote166 views1 answer
Uncomment listen_address=localhost
SQL
13 votes161 views2 answers
Oracle select into and inner join
SQL
0 vote161 views1 answer
Oracle last character of string
SQL
1 vote190 views1 answer
Oracle compile schema
SQL
1 vote165 views1 answer
SQL query to get all table records count from a database
SQL
-1 vote154 views1 answer
Plsql while
SQL
2 votes160 views1 answer
Plsql block
SQL
0 vote183 views1 answer
Sql get year from datetime field
SQL
1 vote180 views1 answer
Oracle sql first day of year
SQL
1 vote186 views1 answer
Delete dublicate rows sql
SQL