SELECT
    a.EMP_CODE AS CODE,
    a.EMP_LAST_NAME AS SURNAME,
    a.EMP_FIRST_NAME AS NAME
FROM
    EMP a
    CROSS JOIN EMP b
WHERE
    a.EMP_CODE != b.EMP_CODE
AND
    a.VALID_FLG = '1'
AND
    b.VALID_FLG = '1'
AND
    REPLACE(a.EMP_LAST_NAME, ' ', '') = REPLACE(b.EMP_LAST_NAME, ' ', '')
AND
    REPLACE(a.EMP_FIRST_NAME, ' ', '') = REPLACE(b.EMP_FIRST_NAME, ' ', '')
ORDER BY
    REPLACE(a.EMP_LAST_NAME, ' ', '') ASC,
    a.EMP_CODE ASC