sql pagination oracle

Solutions on MaxInterview for sql pagination oracle by the best coders in the world

showing results for - "sql pagination oracle"
Ronald
16 May 2018
1SELECT * FROM (
2    SELECT a.*, rownum rn
3    FROM (
4        SELECT * FROM ORDERS WHERE CustomerID LIKE 'A%'
5        ORDER BY OrderDate DESC, ShippingDate DESC
6    ) a
7    WHERE rownum < ((pageNumber * pageSize) + 1 )
8)
9WHERE rn >= (((pageNumber-1) * pageSize) + 1);