56,687
社区成员
发帖
与我相关
我的任务
分享
-- 日期1登录而日期2没登录
select loginid from tb where logintime between @日期1 and @日期2
group by loginid
having timestampdiff(day, min(logintime), max(logintime)) < timestampdiff(day, @日期1, @日期2)
;
-- 最后一次登录时间
select loginid, max(logintime) from tb
where logintime between @日期1 and @日期2
group by loginid