SQL问题：如何找出登陆记录中大于三分钟以上的上一次登陆记录

SQL问题：如何找出登陆记录中大于三分钟以上的上一次登陆记录
表结构：data为时间属性，需要找出与查询时间相隔大于三分钟以上的登陆时间以来显示上次登陆时间，且需要加limte 1

SELECT * FROM sys_user WHERE date(data) < DATE_SUB(NOW(), INTERVAL 3 MINUTE) ORDER BY data DESC LIMIT 1;

select * from table  where DATEDIFF(minute,'登录时间',getdate())  >=3   limit 1;

select t1.ip,max(t1.date) last_time
from table_name t1
left join (
select ip from table_name group by ip having TIMESTAMPDIFF(MINUTE,data,now()) > 3) t2 
on t1.ip = t2.ip
group by t1.ip 

select t1.ip,max(t1.date) last_time
from table_name t1
left join (
select ip from table_name group by ip having TIMESTAMPDIFF(MINUTE,data,now()) > 3) t2 
on t1.ip = t2.ip
group by t1.ip 

您好，我是有问必答小助手，您的问题已经有小伙伴帮您解答，感谢您对有问必答的支持与关注！
PS：问答VIP年卡 【限时加赠：IT技术图书免费领】，了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632