SELECT EMP1.EMP_CODE AS CODE, EMP1.EMP_LAST_NAME AS SURNAME, EMP1.EMP_FIRST_NAME AS NAME
FROM EMP AS EMP1
INNER JOIN EMP AS EMP2 ON TRIM(REPLACE(EMP1.EMP_LAST_NAME, ' ', '')) = TRIM(REPLACE(EMP2.EMP_LAST_NAME, ' ', '')) 
                        AND TRIM(REPLACE(EMP1.EMP_FIRST_NAME, ' ', '')) = TRIM(REPLACE(EMP2.EMP_FIRST_NAME, ' ', ''))
                        AND EMP1.EMP_CODE < EMP2.EMP_CODE
WHERE EMP1.VALID_FLG = '1'
ORDER BY TRIM(REPLACE(EMP1.EMP_LAST_NAME, ' ', '')), TRIM(REPLACE(EMP1.EMP_FIRST_NAME, ' ', '')), EMP1.EMP_CODE;