select * from
(
??? select t.*,rownum r from
??? (
???? select? * from tablea order by id desc
??? ) t where rownum<=10
)
where r>2
?
select * from
(
??? select t.*,rownum r from
??? (
???? select? * from tablea order by id desc
??? ) t where rownum<=10
)
where r>2
?