SELECT EMP_CODE AS 'CODE',
      EMP_LAST_NAME AS 'SURNAME',
      EMP_FIRST_NAME AS 'NAME'
FROM EMP
WHERE VALID_FLG = '1'
AND replace(EMP_LAST_NAME, ' ', '') || replace(EMP_FIRST_NAME, ' ', '')  IN (
        SELECT replace(EMP_LAST_NAME, ' ', '') || replace(EMP_FIRST_NAME, ' ', '') AS '氏名'
        FROM EMP
        GROUP BY 氏名
        HAVING COUNT(*) > 1
    )
ORDER BY replace(EMP_LAST_NAME, ' ', '') || replace(EMP_FIRST_NAME, ' ', ''), EMP_CODE