使用TOP N的几种方式

使用伪列rownum来实现TOP-5的查询：
SQL> select ename,sal 
  2  from
  3  (select ename,sal from emp order by sal desc)
  4  where rownum<=5
  5  /

ENAME                       SAL
-------------------- ----------
KING                       5000
SCOTT                      3000
FORD                       3000
JONES                      2975
BLAKE                      2850

第二种：使用分析函数row_number(),如下：
SQL> select ename,sal
  2  from 
  3  (select ename,sal,
  4   row_number() over(order by sal desc) seq from emp)
  5  where seq<=5
  6  /

ENAME                       SAL
-------------------- ----------
KING                       5000
SCOTT                      3000
FORD                       3000
JONES                      2975
BLAKE