SQL 分组取第一条

 

1 select b.Id, c.* from (select ROW_NUMBER() over (partition by Id order by CreateTImedesc) rownum ,* from table1) c  where c.rownum =1

 

posted @ 2021-12-28 16:42  Shin'Ra  阅读(172)  评论(0)  编辑  收藏  举报