select * from(select a1.*, rownum.rn from(select *from emp) a1 where rownum<=10) where rn>=6;
oracle分页sql语句
原文：http://www.cnblogs.com/linkhtml/p/5515875.html
