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

17 votes191 views4 answers
Sort by mysql
SQL
0 vote249 views1 answer
Postgres full text search example
SQL
2 votes180 views1 answer
Oracle run_duration average
SQL
10 votes188 views6 answers
Mysql delete duplicates
SQL
23 votes237 views6 answers
Create table sql
SQL
0 vote240 views1 answer
Sql convert float to string
SQL
0 vote192 views1 answer
Syntax for changing column size in mysql
SQL
0 vote186 views1 answer
RowDataPacket
SQL
0 vote161 views1 answer
Mysql timeout 30 seconds
SQL
0 vote189 views2 answers
Azure sql-datenbank
SQL