需要两个字段,分组字段、时间排序字段,sql如下:
SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY 分组字段 ORDER BY 时间字段 DESC) rn FROM 表名) t WHERE rn = 1
需要两个字段,分组字段、时间排序字段,sql如下:
SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY 分组字段 ORDER BY 时间字段 DESC) rn FROM 表名) t WHERE rn = 1