Table of Contents

About

Top 'N' Analysis in general refers to getting the top-n rows from a result set.

Example

find the top 3 employees ranked by salary:

  select * 
    from ( select ename from emp order by sal )
   where rownum <= 3;

thats a top-n type query.

Documentation / Reference