SELECT DISTINCT E1.EMP_CODE AS CODE, E1.EMP_LAST_NAME AS SURNAME, E1.EMP_FIRST_NAME AS NAME
FROM EMP E1 CROSS JOIN EMP E2
ON E1.VALID_FLG = '1' AND E2.VALID_FLG = '1' AND E1.EMP_CODE <> E2.EMP_CODE
AND REPLACE(E1.EMP_LAST_NAME, ' ', '') = REPLACE(E2.EMP_LAST_NAME, ' ', '') AND REPLACE(E1.EMP_FIRST_NAME, ' ', '') = REPLACE(E2.EMP_FIRST_NAME, ' ', '')
ORDER BY REPLACE(SURNAME || NAME, ' ', ''), CODE;