Oracle数据库查询分页数据SQL语句:
select * from
(select a.*,rownum row_num from
(select * from mytable t order by t.id desc) a
) b
where b.row_num between 1 and 10
Oracle数据库查询分页数据SQL语句:
select * from
(select a.*,rownum row_num from
(select * from mytable t order by t.id desc) a
) b
where b.row_num between 1 and 10
转载于:https://www.cnblogs.com/forever2698/p/4539934.html