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;
分段查询6到10条记录
最新推荐文章于 2024-07-29 11:08:51 发布