select EMP_CODE as 'CODE'
, EMP_LAST_NAME as 'SURNAME'
, EMP_FIRST_NAME as 'NAME'
from EMP
where REPLACE(EMP_LAST_NAME,' ','')||REPLACE(EMP_FIRST_NAME,' ','') in (
select REPLACE(EMP_LAST_NAME,' ','')||REPLACE(EMP_FIRST_NAME,' ','')
from emp
where VALID_FLG = '1'
group by REPLACE(EMP_LAST_NAME,' ','')||REPLACE(EMP_FIRST_NAME,' ','')
having count(REPLACE(EMP_LAST_NAME,' ','')||REPLACE(EMP_FIRST_NAME,' ',''))>1)
order by REPLACE(EMP_LAST_NAME,' ','')||REPLACE(EMP_FIRST_NAME,' ',''), emp_code;