select
  EMP_CODE as CODE,
  EMP_LAST_NAME as SURNAME,
  EMP_FIRST_NAME as NAME
from
  EMP
where
  exists (
    select 1
    from EMP EMP2
    where EMP_LAST_NAME = EMP2.EMP_LAST_NAME
      and EMP_FIRST_NAME = EMP2.EMP_FIRST_NAME
      and EMP_CODE != EMP2.EMP_CODE
  )
order by
  EMP_LAST_NAME | EMP_FIRST_NAME,
  EMP_CODE