Oracle 基本查询 查看排名

Oracle 基本查询 查看排名

1- 求排名前6-10 的员工

方法一：

select employee, salary
  from (
    select employee, salary, row_number() over (order by salary desc) r
      from salary_table
  )
where r between 6 and 10;

======================================

方法二：
select employee, salary
  from (
    select employee, salary, rank() over (order by salary desc) r
      from salary_table
  )
where r between 6 and 10;

更多Oracle相关信息见Oracle 专题页面 http://www.bkjia.com/topicnews.aspx?tid=12