.Net  
select *from (select empno,MGR,hiredate,row_number() over(partition by MGR order by hiredate desc) as currowid  from emp)where currowid = 1;
posted on 2007-06-14 00:04  东方新秀  阅读(4968)  评论(0编辑  收藏  举报