oracle取最近一个时间的记录

select *from (select empno,MGR,hiredate,row_number() over(partition by MGR order by hiredate desc) as currowid  from emp)where currowid = 1;