oracle取前10条记录

--oracle取前十条数据
--(1)第一种
select * from t_base_employee where rownum < 11;

--(2)第二种
select * from (select * from t_base_employee t order by t.modify_time desc) where rownum <= 10;

 

文章来自:https://www.cnblogs.com/henuyuxiang/p/11609174.html
© 2021 jiaocheng.bubufx.com  联系我们
ICP备案:鲁ICP备09046678号-3