About
Top 'N' Analysis in general refers to getting the top-n rows from a result set.
Articles Related
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.