WITH basedata AS(
	SELECT
	    EMP_CODE AS CODE
	    ,EMP_LAST_NAME AS SURNAME
	    ,EMP_FIRST_NAME AS NAME
		,REPLACE(EMP_LAST_NAME,' ','') AS hanSURNAME
		,REPLACE(EMP_FIRST_NAME,' ','') AS hanNAME
		,EMP_KANA_NAME
		,EMP_ENG_NAME
	FROM EMP
	WHERE VALID_FLG = '1'
)
SELECT
	t1.CODE
	,t1.SURNAME
	,t1.NAME
FROM basedata AS t1
INNER JOIN	basedata AS t2
	ON t1.CODE <> t2.CODE
	AND t1.hanSURNAME = t2.hanSURNAME
	AND t1.hanNAME = t2.hanNAME
ORDER BY t1.hanSURNAME,t1.hanNAME,t1.CODE