SELECT
  EMP.EMP_CODE AS CODE,
  EMP.EMP_LAST_NAME AS SURNAME,
  EMP.EMP_FIRST_NAME AS "NAME"
FROM
  (
  SELECT
    EMP_KANA_NAME,
    COUNT(EMP_KANA_NAME) AS CN
  FROM
    EMP
  WHERE
    VALID_FLG = 1
  GROUP BY
    EMP_KANA_NAME
  HAVING
    COUNT(EMP_KANA_NAME) > 1
  ) AS CNT
  INNER JOIN EMP ON EMP.EMP_KANA_NAME = CNT.EMP_KANA_NAME
ORDER BY
  SURNAME,
  "NAME"