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 vote354 views1 answer
Convert to hexadecimal sql
SQL
1 vote369 views1 answer
Mysql update inner
SQL
0 vote323 views2 answers
How to use aggregate functions in sql
SQL
27 votes336 views6 answers
Set password mysql
SQL
0 vote355 views1 answer
Sql with example
SQL
0 vote303 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote370 views1 answer
Snowflake drop column
SQL
0 vote340 views1 answer
Search In the Database using Text
SQL
0 vote375 views1 answer
Delete from IN subquery
SQL
0 vote320 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL