56,682
社区成员
发帖
与我相关
我的任务
分享
select * from tb a where not exists( select * from tb b where a.member_id=b.member_id and b.apply_time > a.apply_time)
select * from(
select member_id, max(apply_time) as apply_time from tb group by member_id
) a, tb as b
where a.member=b.member and a. apply_time=b. apply_time