SQL> select * from (select employees.*,dense_rank() over (order by salary) rank from employees)
2 where rank=5;
怎样用Sql语句实现查找一列中第N大值?
最新推荐文章于 2021-11-05 11:56:26 发布
SQL> select * from (select employees.*,dense_rank() over (order by salary) rank from employees)
2 where rank=5;