select 人名,max(lastlogin) logtime from 表group by 人名 having (sysdate - to_date(logtime,'yyyymmdd')) > 60;
Select t.fname,t.lastlogin From (select f.fname, f.lastlogin, row_number() Over(Partition By f.fname order by f.lastlogin desc) As Rid from ftable f) t Where (sysdate - to_date(t.lastlogin, 'yyyymmdd')) > 60 And t.rid = 1
having (sysdate - to_date(logtime,'yyyymmdd')) > 60;
From
(select f.fname,
f.lastlogin,
row_number() Over(Partition By f.fname order by f.lastlogin desc) As Rid
from ftable f) t
Where (sysdate - to_date(t.lastlogin, 'yyyymmdd')) > 60
And t.rid = 1