34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT a.*
FROM tb a INNER JOIN
(SELECT tid,memo,MAX(TIME) FROM tb GROUP BY tid,memo)b
ON a.Time=b.Time
select a.* from tb a
join (select tid,memo,max(time) from tb group by tid,memo) b
on a.time=b.time