随笔分类 -  MSSQL

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 阅读(193) 评论(0) 推荐(0)