create temporary table TEST01 
as
select
    EMP_CODE
    ,EMP_LAST_NAME
    ,EMP_FIRST_NAME
    ,EMP_LAST_NAME as LN
    ,EMP_FIRST_NAME as FN
from
    EMP
where
    VALID_FLG='1'
;

UPDATE TEST01 SET LN = REPLACE(LN, ' ', '');
UPDATE TEST01 SET LN = REPLACE(LN, ' ', '');
UPDATE TEST01 SET LN = REPLACE(LN, ' ', '');
UPDATE TEST01 SET LN = REPLACE(LN, ' ', '');
UPDATE TEST01 SET LN = REPLACE(LN, ' ', '');
UPDATE TEST01 SET LN = REPLACE(LN, ' ', '');
UPDATE TEST01 SET LN = REPLACE(LN, ' ', '');
UPDATE TEST01 SET LN = REPLACE(LN, ' ', '');
UPDATE TEST01 SET LN = REPLACE(LN, ' ', '');
UPDATE TEST01 SET LN = REPLACE(LN, ' ', '');

UPDATE TEST01 SET FN = REPLACE(FN, ' ', '');
UPDATE TEST01 SET FN = REPLACE(FN, ' ', '');
UPDATE TEST01 SET FN = REPLACE(FN, ' ', '');
UPDATE TEST01 SET FN = REPLACE(FN, ' ', '');
UPDATE TEST01 SET FN = REPLACE(FN, ' ', '');
UPDATE TEST01 SET FN = REPLACE(FN, ' ', '');
UPDATE TEST01 SET FN = REPLACE(FN, ' ', '');
UPDATE TEST01 SET FN = REPLACE(FN, ' ', '');
UPDATE TEST01 SET FN = REPLACE(FN, ' ', '');
UPDATE TEST01 SET FN = REPLACE(FN, ' ', '');



select
    E1.EMP_CODE as CODE
    ,E1.EMP_LAST_NAME as SURNAME
    ,E1.EMP_FIRST_NAME as NAME
from
    TEST01 E1
    inner join
        TEST01 E2
        on
            E1.FN=E2.FN
            and
            E1.LN=E2.LN
            and
            E1.EMP_CODE <> E2.EMP_CODE
order by 
    E1.FN
    ,E1.LN
    ,1