此问题在此处已有答案：

Selecting the second row of a table using rownum（10个答案）
29天前关闭
select * from（select * from（select emp_salary from employee order by emp_salary）where rownum<6 order by emp_salary）where rownum =6;
在上面的查询rownum是不工作，如果我将运行下面的查询然后rownum是工作，我感到困惑，请帮助
select * from（select * from（select emp_salary from employee order by emp_salary）where rownum<6 order by emp_salary）where rownum =1;
select * from（select * from（select emp_salary from employee order by emp_salary）where rownum<6 order by emp_salary）where rownum =1;