--查询6-10行数据
select * from
(select t.*,rownum rn from
(select * from topic order by tid) t
where rownum <= 10)
where rn > 5
--查询6-10行数据
select * from
(select t.*,rownum rn from
(select * from topic order by tid) t
where rownum <= 10)
where rn > 5