5.oracle 分页

select tt.* from (select rownum as rw,t.* from (select * from emp) t where rownum<=pageSize*currentPage) tt where rw >(currentPage-1)*pageSize

---