56,677
社区成员
发帖
与我相关
我的任务
分享
select *
from user a left join log b on a.userid=b.loguserid
where not exists (
select 1 from log
where loguserid=b.loguserid
and 帖子时间>b.帖子时间
)
select *
from (
select *
from user left join log on userid=loguserid
order by userid,帖子时间 desc
) t
group by userid