select * from
(select t.*,rownum row_num from
(select * from table_name t order by t.id desc) t
) b where b.row_num between 1 and 10
来个例子:
select * from
(select t.*,rownum row_num from
(select id, resname from t_res t order by t.id desc) t
) b where b.row_num between 1 and 10