Ordinal Data - TopN (Analysis|Function)
1 - About
Top 'N' Analysis in general refers to getting the top-n rows from a result set.
2 - Articles Related
3 - 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.