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

3 votes338 views1 answer
Ssh check mysql version
SQL
0 vote357 views3 answers
Sql delete all except
SQL
0 vote348 views1 answer
T sql cursor tr
SQL
0 vote401 views1 answer
Mysql streaming example
SQL
2 votes357 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote354 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote356 views2 answers
Starts and end with vowel sql
SQL
0 vote336 views1 answer
How to print out column name differently in mysql
SQL
0 vote450 views1 answer
How to rename a database in tsql
SQL
1 vote333 views1 answer
Load sql into mamp
SQL