MySQL 8.0

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

create table DD (id int, EMPLOYEE_ID int, NAME varchar(20))
insert into DD values(1, 100, 'ABLE')
insert into DD values(2, 100, 'ABLE')
insert into DD values(3, 101, 'BAKER')
insert into DD values(4, 101, 'CHARLIE')
insert into DD values(5, 102, 'DOG')
insert into DD values(6, 102, 'EASY')
insert into DD values(7, 102, 'DOG')
select min(id) ID
       , EMPLOYEE_ID
       , NAME
from DD
where EMPLOYEE_ID in ( select e_id 
                       from ( SELECT  name
                                      , count(EMPLOYEE_ID)
                                      , max(EMPLOYEE_ID) e_id
                              FROM DD 
                              group by name) a
                       group by e_id
                       having count(e_id) > 1 )
group by EMPLOYEE_ID
         , NAME;



ID
EMPLOYEE_ID
NAME


3
101
BAKER

4
101
CHARLIE

5
102
DOG

6
102
EASY