.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 东方新秀 阅读(...) 评论(...) 编辑 收藏
 
Copyright © 东方新秀 Powered by: 博客园 模板提供:沪江博客