怎样用Sql语句实现查找一列中第N大值?


SQL> select * from (select employees.*,dense_rank() over (order by salary) rank from employees)
  2  where rank=5;

posted @ 2012-10-26 13:07  残阳飞雪  阅读(818)  评论(0编辑  收藏  举报