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;
