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, ' ', ''), replace(EMP_FIRST_NAME, ' ', '')) in 
        (select replace(EMP_LAST_NAME, ' ', '') last_name, replace(EMP_FIRST_NAME, ' ', '') first_name
         from EMP
         where VALID_FLG = '1'
         group by last_name, first_name
         having count(*) > 1)
order by 
	replace(EMP_LAST_NAME, ' ', ''), replace(EMP_FIRST_NAME, ' ', ''), EMP_CODE