select *
from (select t.*,
row_number() over(partition by t.可能有多条重复的id字段 order by t.时间字段 desc) r
from 表 t) c
where r = 1;
select *
from (select t.*,
row_number() over(partition by t.可能有多条重复的id字段 order by t.时间字段 desc) r
from 表 t) c
where r = 1;