oracle分页查找。

 

select *

from (select rownum rn, employees.*

      from employees where rownum <=30)

where rn between 21 and 30