SELECT 
 EMP_CODE AS CODE,
 EMP_LAST_NAME AS SURNAME,
 EMP_FIRST_NAME AS NAME
FROM EMP   EMP1
  INNER JOIN (
SELECT
  EMP_KANA_NAME
FROM EMP
GROUP BY EMP_KANA_NAME
HAVING  COUNT(EMP_KANA_NAME) > 1
  ) EMP2
ON EMP1.EMP_KANA_NAME = EMP2.EMP_KANA_NAME
ORDER BY CODE