MySQL 5.6

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

create table master_employee(employee_name varchar(25), cam_manager_name varchar(25),employee_code varchar(20));
insert into master_employee values ('Rosdiana','','EMP0000001');
insert into master_employee values ('Yenny Widyastuti','', 'EMP0000002');
insert into master_employee values ('x','Yenny Widyastuti','EMP00000025');
insert into master_employee values ('Darmawan','Rosdiana','EMP0000009');
insert into master_employee values ('Gabrielle Margareth','Rosdiana','EMP0000010');
insert into master_employee values ('Malini','Rosdiana','EMP0000011');
insert into master_employee values ('Rony Sandjaya','Rosdiana','EMP0000012');
insert into master_employee values ('Devina Erlyana','Yenny Widyastuti','EMP0000016');
insert into master_employee values ('Stephanie Matuankotta','Yenny Widyastuti','EMP0000006');
select * from master_employee;


employee_name
cam_manager_name
employee_code


Rosdiana

EMP0000001

Yenny Widyastuti

EMP0000002

x
Yenny Widyastuti
EMP00000025

Darmawan
Rosdiana
EMP0000009

Gabrielle Margareth
Rosdiana
EMP0000010

Malini
Rosdiana
EMP0000011

Rony Sandjaya
Rosdiana
EMP0000012

Devina Erlyana
Yenny Widyastuti
EMP0000016

Stephanie Matuankotta
Yenny Widyastuti
EMP0000006


select me1.employee_name,me1.cam_manager_name, me1.employee_code 
from master_employee me1 inner join 
  (
    select employee_name, cam_manager_name, 
    min(employee_code) employee_code
    from master_employee
    group by employee_name
 ) me2
on me1.employee_name=me2.employee_name
and me1.employee_code <> me2.employee_code
union
(select employee_name, cam_manager_name, 
    min(employee_code) employee_code 
from master_employee
group by 2,1)
;


employee_name
cam_manager_name
employee_code


Rosdiana

EMP0000001

Yenny Widyastuti

EMP0000002

Darmawan
Rosdiana
EMP0000009

Gabrielle Margareth
Rosdiana
EMP0000010

Malini
Rosdiana
EMP0000011

Rony Sandjaya
Rosdiana
EMP0000012

Devina Erlyana
Yenny Widyastuti
EMP0000016

Stephanie Matuankotta
Yenny Widyastuti
EMP0000006

x
Yenny Widyastuti
EMP00000025

employee_name	cam_manager_name	employee_code
Rosdiana		EMP0000001
Yenny Widyastuti		EMP0000002
x	Yenny Widyastuti	EMP00000025
Darmawan	Rosdiana	EMP0000009
Gabrielle Margareth	Rosdiana	EMP0000010
Malini	Rosdiana	EMP0000011
Rony Sandjaya	Rosdiana	EMP0000012
Devina Erlyana	Yenny Widyastuti	EMP0000016
Stephanie Matuankotta	Yenny Widyastuti	EMP0000006