因为rownum只能用<,<=，所以将rn当成真实的一列供外部查询语句查询。
Oracle语句
标签：
Oracle语句
rn,last_name,salary from(
select rownum rn,last_name,salary from(
select last_name,salary from employees order by salary desc
)
) where rn>10 and rn<=20