在oracle中怎么查询排序在前十的语句

Answer 1

select * from (select rownum num, a.* from table1 order by 排序关键字)
where num<11

Answer 2

select * from table where 1=1 order by id desc number 10

Answer 3

select * from table where rownum < 11

Answer 4

select * from XX where rownumber<=10;