分段查询6到10条记录

SQL分段查询6到10条记录：
无条件时：
select * from (select a1.,rownum rn from (select * from 目标表) a1 where rownum<=10) where rn>=6;
有某条件时：
select * from
(select b.,rownum rn from (select a.* from 目标表 a order by 目标字段) b)
where rn between 6 and 10;