select
    EMP_CODE as CODE,
    EMP_LAST_NAME as SURNAME,
    EMP_FIRST_NAME as NAME
from EMP
where
    EMP_KANA_NAME = (
        select
            EMP_KANA_NAME
        from (
            select
                EMP_KANA_NAME,
                count(EMP_KANA_NAME) as count
            from EMP
            where 
                VALID_FLG = '1'
            group by EMP_KANA_NAME
        )
        where
            count > 1
    )