34,576
社区成员
发帖
与我相关
我的任务
分享
select * from tb a where exists (select 1 from tb where a.id=id
group by id having max(time)=a.time)
SELECT *
FROM TB a
WHERE EXISTS ( SELECT 1
FROM ( SELECT id ,
MAX([time]) [time]
FROM TB
GROUP BY id
) b
WHERE a.id = b.id
AND a.[time] = b.[time] )