-- select * from EMP;
select
  EMP_CODE as CODE,
  EMP_LAST_NAME as SURNAME,
  EMP_FIRST_NAME as NAME
from
  EMP EMP2
where
  VALID_FLG = '1'
  and exists (
    select 1
    from EMP
    where replace(EMP_LAST_NAME,' ','') = replace(EMP2.EMP_LAST_NAME,' ','')
      and replace(EMP_FIRST_NAME,' ','') = replace(EMP2.EMP_FIRST_NAME,' ','')
      and EMP_CODE != EMP2.EMP_CODE
      and VALID_FLG = '1'
  )
order by
  replace(EMP_LAST_NAME,' ',''),
  replace(EMP_FIRST_NAME,' ',''),
  EMP_CODE