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