select EMP.EMP_CODE as CODE, EMP.EMP_LAST_NAME as SURNAME, EMP.EMP_FIRST_NAME as NAME
from EMP
where REPLACE(EMP.EMP_LAST_NAME || EMP.EMP_FIRST_NAME,' ','') in (
    select REPLACE(e_sub.EMP_LAST_NAME || e_sub.EMP_FIRST_NAME,' ','')
    from EMP e_sub
    where e_sub.VALID_FLG = 1
    group by REPLACE(e_sub.EMP_LAST_NAME || e_sub.EMP_FIRST_NAME,' ','')
    having count(e_sub.EMP_CODE) >= 2
    )
order by REPLACE(EMP.EMP_LAST_NAME || EMP.EMP_FIRST_NAME,' ',''), EMP.EMP_CODE