3,491
社区成员
发帖
与我相关
我的任务
分享
select * from Table a where a.UPDATETIME=(select max(UPDATETIME) from Table where PID=a.PID)
select pid,max(UPDATETIME ) from table group by pid
select pid,UPDATETIME
from (select pid,UPDATETIME,
row_number() over (partition by pid order by UPDATETIME desc) rn
from table )
where rn = 1
select *
from (select t.*, row_number() over (order by datetime desc) as rnum
from tbl t)
where rnum = 1;