select
EMP.EMP_CODE as CODE,
EMP.EMP_LAST_NAME as SURNAME,
EMP.EMP_FIRST_NAME as NAME
from 
    (
    SELECT
    EMP_CODE,
        COUNT(REPLACE(EMP_LAST_NAME,' ','')  || REPLACE(EMP_FIRST_NAME,' ','')) AS CNT
    FROM
        EMP
    GROUP BY REPLACE(EMP_LAST_NAME,' ','')  || REPLACE(EMP_FIRST_NAME,' ','') 
    ) AS EMP1
left outer join EMP
on EMP1.EMP_CODE = EMP.EMP_CODE
where VALID_FLG  = 1
and EMP1.CNT > 1
order by REPLACE(EMP_LAST_NAME,' ','')  || REPLACE(EMP_FIRST_NAME,' ','') ,EMP.EMP_CODE asc