Oracle pagination query offset

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 vote155 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote143 views1 answer
Oracle sql procedure return value
SQL
0 vote228 views1 answer
Install ms sql server management studio
SQL
1 vote149 views1 answer
Mysql change root mysql_native_password
SQL
0 vote165 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote151 views4 answers
Change schema in sql server
SQL
32 votes141 views6 answers
Insert select
SQL
0 vote166 views1 answer
How to get parent and child record in single query using sql
SQL
1 vote134 views1 answer
PLS-00225 type
SQL
0 vote139 views1 answer
Mysql disable query caching
SQL