select EMP1.EMP_CODE as CODE, EMP1.EMP_LAST_NAME as SURNAME, EMP1.EMP_FIRST_NAME as NAME
from EMP as EMP1
inner join EMP as EMP2
on replace(EMP1.EMP_LAST_NAME, ' ','') = replace(EMP2.EMP_LAST_NAME, ' ','')
and replace(EMP1.EMP_FIRST_NAME, ' ','') =  replace(EMP2.EMP_FIRST_NAME,' ','')
where EMP1.VALID_FLG = '1' and EMP2.VALID_FLG = '1'
group by EMP1.EMP_CODE 
having count(*) >= 2
order by REPLACE(EMP1.EMP_LAST_NAME, ' ', ''), EMP1.EMP_CODE