select * from (
select
UI.username,
pld.logintime as logindatetime,
pld.LogoutTime as logoutdatetime,
ld.LoginFrom,
ld.ipAddress,
p.ProjectName,
row_number() over(partition by username order by logindatetime desc) as sn
from
tbl_pj_userinfo ui,
tbl_pj_LoginDetails ld,
tbl_pj_ProjectLoginDetails pld,
tbl_pj_ProjectSetup p
where
pld.DetailsID=ld.DetailsID and
ui.IsUserDeactivated=0 and
ui.UserID=ld.UserId and
p.ProjectID =pld.ProjectID
)a
where sn=1 and logoutdatetime is null order by logindatetime desc
Comments
0 comments
Please sign in to leave a comment.