select
  EMP_CODE as CODE,
  EMP_LAST_NAME as SURNAME,
  EMP_FIRST_NAME as NAME
  from emp
 where VALID_FLG is '1' AND
       replace(EMP_LAST_NAME || EMP_FIRST_NAME, ' ', '') IN (
         select replace(EMP_LAST_NAME || EMP_FIRST_NAME, ' ', '')
           from emp
          where VALID_FLG is '1'
          group by replace(EMP_LAST_NAME || EMP_FIRST_NAME, ' ', '')
         having count(replace(EMP_LAST_NAME || EMP_FIRST_NAME, ' ', '')) > 1)
 order by
   replace(EMP_LAST_NAME || EMP_FIRST_NAME, ' ', '') asc,
   EMP_CODE asc
       ;