select
    EMP.EMP_CODE as CODE,
    EMP.EMP_LAST_NAME as SURNAME,
    EMP.EMP_FIRST_NAME as NAME
from
 EMP
inner join
    (
        select
            REPLACE(EMP_LAST_NAME, ' ', '') as EMP_LAST_NAME,
            REPLACE(EMP_FIRST_NAME, ' ', '') as EMP_FIRST_NAME,
            count (*) as count
        from
            EMP
        where
            VALID_FLG = '1'
        group by
            REPLACE(EMP_LAST_NAME, ' ', ''),
            REPLACE(EMP_FIRST_NAME, ' ', '')
        having
            count (*) > 1
    )as EMP2
    on REPLACE(EMP.EMP_LAST_NAME, ' ', '') = REPLACE(EMP2.EMP_LAST_NAME, ' ', '')
    and REPLACE(EMP.EMP_FIRST_NAME, ' ', '') = REPLACE(EMP2.EMP_FIRST_NAME, ' ', '')
order by
    REPLACE(EMP.EMP_LAST_NAME, ' ', ''),
    EMP.EMP_CODE