oracle中没有TOP方法 可以用两种方式 按需行事
1. rownum虚列
select * from tab where rownum<XXX
2.分析函数:
row_number() over ( partition by col1 order by col2 )比如想取出100-150条记录,按照tname排序:select tname,tabtype from ( select tname,tabtype,row_number() over ( order by tname ) rn from tab ) where rn between 100 and 150;