SELECT
    distinct 
    CODE
    ,SURNAME
    ,NAME
FROM(
    SELECT
        t1.EMP_CODE as CODE
        ,t1.EMP_LAST_NAME as SURNAME
        ,t1.EMP_FIRST_NAME as NAME
        ,count(t1.EMP_CODE) over (partition by t1.EMP_CODE) as x
        ,replace(t1.EMP_LAST_NAME,' ','')||replace(t1.EMP_FIRST_NAME,' ','') as y
    FROM
        EMP t1
    inner join EMP t2 on
        replace(t1.EMP_LAST_NAME,' ','')||replace(t1.EMP_FIRST_NAME,' ','')
        =replace(t2.EMP_LAST_NAME,' ','')||replace(t2.EMP_FIRST_NAME,' ','')
        and t2.VALID_FLG = '1'
    WHERE
        t1.VALID_FLG = '1'
)
WHERE
    x >= 2
ORDER BY 
     y asc
    ,CODE asc