SELECT
	t1.CODE
	,t1.SURNAME
	,t1.NAME
FROM
	(
	SELECT
	    EMP_CODE AS CODE
		,REPLACE(EMP_LAST_NAME,' ','') AS SURNAME
		,REPLACE(EMP_FIRST_NAME,' ','') AS NAME
		,REPLACE(EMP_LAST_NAME,' ','') || REPLACE(EMP_FIRST_NAME,' ','') AS seimei
	FROM EMP
	WHERE VALID_FLG = '1'
	) AS t1
CROSS JOIN
	(
	SELECT
	    EMP_CODE AS CODE
		,REPLACE(EMP_LAST_NAME,' ','') AS SURNAME
		,REPLACE(EMP_FIRST_NAME,' ','') AS NAME
	FROM EMP
	WHERE VALID_FLG = '1'
	) AS t2
WHERE t1.CODE <> t2.CODE
	AND t1.SURNAME = t2.SURNAME
	AND t1.NAME = t2.NAME
ORDER BY t1.seimei,t1.CODE