select * from (select a1.*,rownum rn from(select * from emp) a1 where rownum<=10) where rn>=6; 转载于:https://blog.51cto.com/haidao/293329