Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table find_last_version 
( date_ date,
  name varchar2(100 char),
  last_version number
);
insert into find_last_version (date_, name, last_version) values (to_date('2022-05-10','yyyy-mm-dd'), 'ACA - Atelliers de convresation angalise', 211362);
1 rows affected

insert into find_last_version (date_, name, last_version) values (to_date('2022-05-11','yyyy-mm-dd'), 'ACA - Atelliers de convresation angalise', 211362);
1 rows affected

insert into find_last_version (date_, name, last_version) values (to_date('2022-05-12','yyyy-mm-dd'), 'ACA - Atelliers de convresation angalise', 212241);
1 rows affected

insert into find_last_version (date_, name, last_version) values (to_date('2022-05-13','yyyy-mm-dd'), 'ACA - Atelliers de convresation angalise', 212241);
1 rows affected

insert into find_last_version (date_, name, last_version) values (to_date('2022-05-14','yyyy-mm-dd'), 'ACA - Atelliers de convresation angalise', 212241);
1 rows affected

select date_, name, last_version
  from (select date_, name, last_version,
               row_number() over (partition by last_version order by date_ asc) as row_num,
               dense_rank() over ( order by last_version desc) as d_rank
          from find_last_version f)
 where d_rank = 1 and row_num = 1


DATE_
NAME
LAST_VERSION


12-MAY-22
ACA - Atelliers de convresation angalise
212241