Ordinal Data - TopN (Analysis|Function)

1 - About

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

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.

4 - Documentation / Reference

data/sort/topn.txt ยท Last modified: 2017/09/13 16:16 by gerardnico