SELECT
    EMP.EMP_CODE AS CODE
    , EMP.EMP_LAST_NAME AS SURNAME
    , EMP.EMP_FIRST_NAME AS NAME
FROM
    EMP
    INNER JOIN EMP E USING(EMP_CODE)
WHERE
    EMP.VALID_FLG = '1'
    AND REPLACE(EMP.EMP_LAST_NAME,' ','')  = REPLACE(E.EMP_LAST_NAME,' ','')
    AND REPLACE(EMP.EMP_FIRST_NAME,' ','') =  REPLACE(E.EMP_FIRST_NAME,' ','')
ORDER BY REPLACE(EMP.EMP_LAST_NAME,' ','')||REPLACE(EMP.EMP_FIRST_NAME,' ','') ASC, EMP_CODE ASC;