SELECT
	T2.EMP_CODE AS CODE
	,T2.EMP_LAST_NAME AS SURNAME
	,T2.EMP_FIRST_NAME AS NAME
FROM(
    SELECT
    	EMP_LAST_NAME
    	,EMP_FIRST_NAME
    	,replace(EMP_LAST_NAME || EMP_FIRST_NAME,' ','') AS EMP_NAME
    	,COUNT(replace(EMP_LAST_NAME || EMP_FIRST_NAME,' ','')) AS CNT
    FROM
    	EMP
    WHERE
	    VALID_FLG = '1'
    GROUP BY
	    EMP_NAME
	  ) T1
INNER JOIN (
    SELECT
        EMP_CODE
        ,EMP_LAST_NAME
        ,EMP_FIRST_NAME
        ,replace(EMP_LAST_NAME || EMP_FIRST_NAME,' ','') AS EMP_NAME
    FROM
        EMP
)T2
ON
    T1.EMP_NAME = T2.EMP_NAME
AND
	T1.CNT > 1
ORDER BY
    T1.EMP_NAME,T2.EMP_CODE