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(1)
        from
            EMP
        where
            VALID_FLG = '1'
        group by
            replace(EMP_LAST_NAME, ' ', ''),
            replace(EMP_FIRST_NAME, ' ', '')
        having
            count(1) > 1
    ) as thoufuku 
    on replace(EMP.EMP_LAST_NAME, ' ', '') = thoufuku.EMP_LAST_NAME
    and replace(EMP.EMP_FIRST_NAME, ' ', '') = thoufuku.EMP_FIRST_NAME
where
    VALID_FLG = '1'
order by
    replace(EMP.EMP_LAST_NAME, ' ', ''),
    replace(EMP.EMP_FIRST_NAME, ' ', ''),
    EMP.EMP_CODE