Reporting - Inner N

1 - About

An inner N reporting retrieve a set of rows in a complete data set classified by its row number.

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;

4 - Documentation / Reference

  • Bookmark "Reporting - Inner N" at del.icio.us
  • Bookmark "Reporting - Inner N" at Digg
  • Bookmark "Reporting - Inner N" at Ask
  • Bookmark "Reporting - Inner N" at Google
  • Bookmark "Reporting - Inner N" at StumbleUpon
  • Bookmark "Reporting - Inner N" at Technorati
  • Bookmark "Reporting - Inner N" at Live Bookmarks
  • Bookmark "Reporting - Inner N" at Yahoo! Myweb
  • Bookmark "Reporting - Inner N" at Facebook
  • Bookmark "Reporting - Inner N" at Yahoo! Bookmarks
  • Bookmark "Reporting - Inner N" at Twitter
  • Bookmark "Reporting - Inner N" at myAOL
olap/innern.txt ยท Last modified: 2017/01/20 20:47 by gerardnico