34,587
社区成员
发帖
与我相关
我的任务
分享
SELECT logouttime-logintime FROM [TABLE]
--测试过
select datediff(ss,b.LoginTime,TableLogOut.LoginTime) as seconds,TableLogOut.LoginIP
from PackDetect as b,
(select LoginTime,ltrim(rtrim(substring(LoginName,22,24))) as LoginIP from PackDetect as a where substring(LoginName,8,4) like '退出%'
and LoginTime >= all(select LoginTime from PackDetect where LoginName like rtrim(a.LoginName)+'%')
) as TableLogOut ---求所有最后登出时间及IP
where substring(b.LoginName,8,12) like '%登入到系统%'
and substring(b.LoginName,22,24) like '%'+LoginIP+'%'
and b.LoginTime>=all ---找出相同IP的最后登入时间
(select LoginTime from PackDetect as c
where substring(c.LoginName,8,12) like '%登入到系统%'
and substring(c.LoginName,22,24) like '%'+LoginIP+'%'
)