Sql group by 分组取时间最新的一条数据

取时间最新的记录 不分组有重复(多条CreateTime一样的都是最新记录)

select *from test twherepid in(    select PId from Test t    where    time=(select max(time) from Test t1 where t1.PId=t.PId)    group by Pid)andtime=(select max(time) from Test t1 where t1.PId=t.PId)

分组后取时间最新的记录

SELECT max(Id) , Pid, MAX(Time) as MaxTimeFROM TestGROUP BY pid

如果Id是uuid类型无法使用max(id)的解决办法(使用开窗函数)

select *from(  select     row_number()  over(partition by [Pid] order by [Time] desc  ) as KeyId,* from Test   ) d where KeyId=1

来源地址：https://blog.csdn.net/Wis57/article/details/129201601