用rownum和order by的时候, 是rounum先生成然后才去更具order by的条件进行排序,所以如果order by以后想要分页的话,需要嵌套三层的sql才行: select * from (select rownum ,a.* from (select * from tablename order by something) a) where rownum <10;