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 vote159 views1 answer
Postgres clear table
SQL
0 vote156 views1 answer
Mysql row generator
SQL
0 vote152 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote142 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote287 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote151 views1 answer
Query for backup a database at another location in file system
SQL
9 votes153 views5 answers
Laravel to sql
SQL
0 vote171 views1 answer
Day of the week sqlite
SQL
0 vote168 views1 answer
Import sql inside hide sql
SQL
2 votes138 views1 answer
Alter table add multiple columns postgresql
SQL