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 EMP_NAME from
(select EMP_CODE,REPLACE(EMP_LAST_NAME,' ','') || REPLACE(EMP_FIRST_NAME,' ','') as EMP_NAME from EMP where VALID_FLG= '1'
group by EMP_NAME
having count(*) > 1
)
)
and VALID_FLG= '1'
order by
REPLACE(EMP_LAST_NAME,' ','') || REPLACE(EMP_FIRST_NAME,' ','')
,EMP_CODE