SELECT
    EMP_CODE AS CODE
    ,EMP_LAST_NAME AS SURNAME
    ,EMP_FIRST_NAME AS NAME
FROM EMP
WHERE EMP_KANA_NAME IN (SELECT EMP_KANA_NAME FROM EMP GROUP BY EMP_KANA_NAME HAVING COUNT(EMP_KANA_NAME) >= 2 )
ORDER BY EMP_KANA_NAME, CODE