SELECT DISTINCT CODE1 AS CODE, SURNAME1 AS SURNAME, NAME1 AS NAME
FROM (
    SELECT E1.EMP_CODE AS CODE1, E2.EMP_CODE AS CODE2, E1.EMP_LAST_NAME AS SURNAME1, E2.EMP_LAST_NAME AS SURNAME2, E1.EMP_FIRST_NAME AS NAME1, E2.EMP_FIRST_NAME AS NAME2
    FROM EMP E1 CROSS JOIN EMP E2
    WHERE E1.VALID_FLG = '1' AND E2.VALID_FLG = '1'
)
WHERE CODE1 <> CODE2 AND REPLACE(SURNAME1, ' ', '') = REPLACE(SURNAME2, ' ', '') AND REPLACE(NAME1, ' ', '') = REPLACE(NAME2, ' ', '')
ORDER BY REPLACE(SURNAME || NAME, ' ', '') ASC, CODE ASC;