select 
e1.EMP_CODE as CODE
,e1.EMP_LAST_NAME as SURNAME
,e1.EMP_FIRST_NAME as NAME
from EMP as e1
inner join emp as e2
on trim(REPLACE(e1.EMP_LAST_NAME, ' ', '')) = trim(REPLACE(e2.EMP_LAST_NAME, ' ', ''))
and trim(REPLACE(e1.EMP_FIRST_NAME, ' ', '')) = trim(REPLACE(e2.EMP_FIRST_NAME, ' ', ''))
and e1.EMP_CODE != e2.EMP_CODE
where
e1.VALID_FLG = '1'
and e2.VALID_FLG = '1'
order by
trim(REPLACE(e1.EMP_LAST_NAME, ' ', ''))
, trim(REPLACE(e1.EMP_LAST_NAME, ' ', ''))
, e1.EMP_CODE
;