Reporting - Inner N
1 - About
An inner N reporting retrieve a set of rows in a complete data set classified by its row number.
2 - Articles Related
3 - Inner-n query
The following inner-N query with the Oracle row_number analytic function selects all rows from the employees table but returns only the fifty-first through one-hundredth row:
SELECT last_name FROM (SELECT last_name, ROW_NUMBER() OVER (ORDER BY last_name) R FROM employees) WHERE R BETWEEN 51 AND 100;