ORACLE中获取第一条记录

1.

select * from ( select a.*, rownum as rn from tab_name a order by id asc ) where rn = 1

2.

select * from tab_name where rownum = 1