ibator中倒序SQL排列解决办法

select * from

(

??? select t.*,rownum r from

??? (

???? select? * from tablea order by id desc

??? ) t where rownum<=10

)

where r>2

?