select x1.agr_no,
       x1.from_dat,
       p.tabn3,
       p.family3 Nume,
       p.name3 Prenume,
       o.name_podr23 name_podr23_actual,
       d.naim_dolj9 naim_dolj9_actual,
       (select (select pd.Name_Podr23
                  from podrs pd
                 where pd.code23 = pt.podr_code23)
          from paths pt
         where pt.person_tabn3 = p.tabn3
           and pt.dat_nazn16 =
               (select max(pt1.dat_nazn16)
                  from paths pt1
                 where pt1.person_tabn3 = pt.person_tabn3
                   and pt1.dat_nazn16 < x.dat_nazn161)) Name_Podr_prec,
       (select (select dj.naim_dolj9
                  from Doljnosts dj
                 where dj.code9 = pt.doljnost_code9)
          from paths pt
         where pt.person_tabn3 = p.tabn3
           and pt.dat_nazn16 =
               (select max(pt1.dat_nazn16)
                  from paths pt1
                 where pt1.person_tabn3 = pt.person_tabn3
                   and pt1.dat_nazn16 < x.dat_nazn161)) Dolj_prec,
       x.dat_nazn161
  from persons p,
       shtats s,
       podrs o,
       doljnosts d,
       (select max(t.dat_nazn16) as dat_nazn161, t.person_tabn3
          from paths t
         where t.dat_nazn16 between to_date('01.02.2018', 'dd.mm.yyyy') and
               to_date('28.02.2018', 'dd.mm.yyyy')
           and t.actual = '0'
         group by t.person_tabn3) x,
       (select a1.from_dat, a1.tabn, a1.agr_no
          from bars2.PS_AGRE_PERSONS a1
         where a1.agr_type = 'TWO'
           and trunc(a1.from_dat) = (select max(trunc(a.from_dat)) from_dat
                                       from PS_AGRE_PERSONS a
                                      where a.agr_type = 'TWO'
                                        and a.tabn = a1.tabn
                                      group by a.tabn)) x1
where p.dat_uvolnen3 is null
   and p.tabn3 = s.person_tabn3
   and s.podr_code23 = o.code23
   and s.doljnost_code9 = d.code9
   and p.tabn3 = x.person_tabn3
   and p.tabn3 = x1.tabn

max(t.dat_nazn16)

max(t.dat_nazn16)

...
 select max(t.dat_nazn16) as dat_nazn161, t.person_tabn3
          from paths t
         where t.dat_nazn16 between to_date('01.02.2018', 'dd.mm.yyyy') and
               to_date('28.02.2018', 'dd.mm.yyyy')
           and t.actual = '0'
         group by t.person_tabn3, "местоположение работы"
...

select max(pt1.dat_nazn16)
                  from paths pt1
                 where pt1.person_tabn3 = pt.person_tabn3
                   and pt1.dat_nazn16 < x.dat_nazn161)) Name_Podr_prec,

select max(t.dat_nazn16) as dat_nazn161, t.person_tabn3
          from paths t
         where t.dat_nazn16 between to_date('01.02.2018', 'dd.mm.yyyy') and
               to_date('28.02.2018', 'dd.mm.yyyy')nd t.actual = '0' 
         group by t.person_tabn3) x,

x.dat_nazn161

select (select pd.Name_Podr23
                  from podrs pd
                 where pd.code23 = pt.podr_code23)
          from paths pt
         where pt.person_tabn3 = p.tabn3
           and pt.dat_nazn16 =
               (select max(pt1.dat_nazn16)
                  from paths pt1
                 where pt1.person_tabn3 = pt.person_tabn3
                   and pt1.dat_nazn16 < x.dat_nazn161)) Name_Podr_prec

select (select dj.naim_dolj9
                  from Doljnosts dj
                 where dj.code9 = pt.doljnost_code9)
          from paths pt
         where pt.person_tabn3 = p.tabn3
           and pt.dat_nazn16 =
               (select max(pt1.dat_nazn16)
                  from paths pt1
                 where pt1.person_tabn3 = pt.person_tabn3
                   and pt1.dat_nazn16 < x.dat_nazn161)) Dolj_prec

max(pt1.dat_nazn16)

 x.dat_nazn161

select (select dj.naim_dolj9
                  from Doljnosts dj
                 where dj.code9 = pt.doljnost_code9)
          from paths pt
         where pt.person_tabn3 = p.tabn3
           and pt.dat_nazn16 =
               (select max(pt1.dat_nazn16)
                  from paths pt1
                 where pt1.person_tabn3 = pt.person_tabn3
                   and pt1.dat_nazn16 < t.dat_nazn16)) Dolj_prec,

t.dat_nazn16 between to_date('01.02.2018', 'dd.mm.yyyy') and to_date('28.02.2018', 'dd.mm.yyyy')

 
 1  with paths(person_tabn3, dat_nazn16,cex) as (
  2  select 100,date '2018-02-01',5 from dual union all
  3  select 100,date '2018-02-10',6 from dual union all
  4  select 100,date '2018-02-10',36 from dual union all
  5  select 200,date '2018-02-17',5 from dual )
  6  select person_tabn3,dat_nazn16 dat_nazn161,cex from (
  7   select person_tabn3,dat_nazn16,cex
  8    ,rank() over (partition by t.person_tabn3 order by t.dat_nazn16 desc) r
  9            from paths t
 10           where t.dat_nazn16 between to_date('01.02.2018', 'dd.mm.yyyy') and
 11                 to_date('28.02.2018', 'dd.mm.yyyy')
 12  --           and t.actual = '0'
 13  --         group by t.person_tabn3, "местоположение работы"
 14* ) where r=1