select
    EMP_CODE as CODE,
    EMP_LAST_NAME as SURNAME,
    EMP_FIRST_NAME as NAME
from EMP
join (
    select
        replace(EMP_KANA_NAME," ","") as hurigana,
        count(replace(EMP_KANA_NAME," ","")) as count
    from
        EMP
    where
        VALID_FLG = '1'
    group by
        replace(EMP_KANA_NAME," ","")
) on
    replace(EMP_KANA_NAME," ","") = hurigana
where
    count > 1
order by
    replace(SURNAME," ",""),
    replace(NAME," ",""),
    CODE