select a.EMP_CODE as CODE,
       a.EMP_LAST_NAME as SURNAME,
       a.EMP_FIRST_NAME as NAME
from EMP as a
left join EMP as b
on a.EMP_CODE = b.EMP_CODE
where  REPLACE(a.EMP_LAST_NAME,' ','') || REPLACE(a.EMP_FIRST_NAME,' ','') =
       REPLACE(b.EMP_LAST_NAME,' ','') || REPLACE(b.EMP_FIRST_NAME,' ','') and
       b.VALID_FLG = '1' and
       a.VALID_FLG = '1'
ORDER BY REPLACE(a.EMP_LAST_NAME,' ','') || REPLACE(a.EMP_FIRST_NAME,' ','') ASC, a.EMP_CODE ASC