sql 分组取出表中每组最新日期的数据 

1 select a.* from(select ROW_NUMBER() OVER(PARTITION BY 
2 c.task_id ORDER BY c.submit_date DESC) rn,  c.task_id, 
3 c.submit_date,c.opinion,count(c.task_id) over (partition by 
4 c.task_id) num from CRDS_VOTE_COUNT c) a where a.rn=1

 

posted @ 2020-11-19 14:59  leviH  阅读(1964)  评论(0)    收藏  举报