Oracle分页

select a.* from

(select rownum rw,t.* from (select * from eb_item) t
where rownum < 10) a

where a.rw > 2

嵌套查询