Oracle pagination query rownum

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 vote404 views1 answer
Redirection 301 htaccess nom de domaine
SQL
6 votes196 views1 answer
Oracle trigger after logon on schema
SQL
0 vote189 views1 answer
How to to get current date and time in sql
SQL
0 vote196 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote204 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
0 vote191 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote234 views1 answer
Search In the Data using ObjectName
SQL
0 vote232 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
11 votes369 views4 answers
Round in sql
SQL
0 vote183 views1 answer
Create boolean column in MySQL with false as default value?
SQL