Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tablename (lvl int, kid varchar(10), father varchar(10));
insert into tablename (lvl, kid, father) values (1,	  'POD001',	'DPR001');
1 rows affected

insert into tablename (lvl, kid, father) values (1,	  'POD002',	'DPR002');
1 rows affected

insert into tablename (lvl, kid, father) values (1,	  'POD003',	'POD002');
1 rows affected

insert into tablename (lvl, kid, father) values (2,	  'POD003',	'DPR002');
1 rows affected

insert into tablename (lvl, kid, father) values (2,	  'POD004',	'DPR001');
1 rows affected

insert into tablename (lvl, kid, father) values (1,	  'POD004',	'POD001');
1 rows affected

insert into tablename (lvl, kid, father) values (2,	  'POD005',	'POD002');
1 rows affected

insert into tablename (lvl, kid, father) values (1,	  'POD005',	'POD003');
1 rows affected

insert into tablename (lvl, kid, father) values (3,	  'POD005',	'DPR002');
1 rows affected

select t.*
from tablename t
where not exists (
  select 1 from tablename
  where kid = t.kid and lvl > t.lvl
)
order by t.kid


LVL
KID
FATHER


1
POD001
DPR001

1
POD002
DPR002

2
POD003
DPR002

2
POD004
DPR001

3
POD005
DPR002

LVL	KID	FATHER
1	POD001	DPR001
1	POD002	DPR002
2	POD003	DPR002
2	POD004	DPR001
3	POD005	DPR002