56,677
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM user_log t1 WHERE EXISTS(
SELECT 1 FROM user_log t2 WHERE t1.userid=t2.userid AND DATEDIFF(t2.updatetime,t1.updatetime) IN(1,-1)
)
select *
from user_log t
where exists (
select 1
from user_log
where userid=t.userid
and id!=t.id
and updatetime between t.updatetime - interval 1 day and t.updatetime + interval 1 day
)
order by userid,updatetime