oracle 分页语句

select * from (select ROWNUM rn,a.* from (select  ss.ss_id,ss.BOOST
  from LY_SCENIC_SPOT ss order by boost desc) a )
where rn between 10 and 20