select
*
from
(
a.*,rownum row_num
mytable t
order
by
t.id
desc
) a
) b
where
b.row_num
between
1
and
10