select
  EMP_CODE AS CODE
  , EMP_LAST_NAME AS SURNAME
  , EMP_FIRST_NAME AS NAME
from
  EMP
where
  VALID_FLG = '1'
  and REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME, ' ', '') in (
      select
        REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME, ' ', '') AS NAME
      from
        EMP
      where
        VALID_FLG = '1'
      group by
        NAME
      having
        count(*) >= 2
    )
order by
  REPLACE(EMP_LAST_NAME || EMP_FIRST_NAME, ' ', '')
  , EMP_CODE
;