oracle 实现分组后排序取第一条

1.这里要将数据按PARTNER_ID 分组并且按时间排序取第一

select * from (
SELECT ROW_NUMBER()over(PARTITION by PARTNER_ID ORDER BY VISIT_DATE DESC) as ro,v.PARTNER_ID,v.VISIT_DATE
  from VISIT_INFO v
 where ADDRESS is not null
   and ADDRESS != ' '
) dual  where ro=1

 

关于 PARTITION by 大家可以参考 https://www.cnblogs.com/cjm123/p/8033639.html