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