SELECT * FROM 表名 ORDER BY 入职时间 ASC
select c.* from (select rownum rn,b.* from (select e.* from emp e order by e.hiredate asc) b) c where c.rn=1;