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 REPLACE(e1.EMP_LAST_NAME, ' ', '') = REPLACE(e2.EMP_LAST_NAME, ' ', '')
and REPLACE(e1.EMP_FIRST_NAME, ' ', '') = REPLACE(e2.EMP_FIRST_NAME, ' ', '')
and e1.EMP_CODE != e2.EMP_CODE
where
e1.VALID_FLG = '1'
and e2.VALID_FLG = '1'
order by
REPLACE(e1.EMP_LAST_NAME + e1.EMP_FIRST_NAME, ' ', '')
, e1.EMP_CODE
;