select e.EMP_CODE as CODE, e.EMP_LAST_NAME as SURNAME, e.EMP_FIRST_NAME as NAME
from EMP as e
where REPLACE(e.EMP_LAST_NAME||e.EMP_FIRST_NAME,' ','') in
(
select REPLACE(p.EMP_LAST_NAME||p.EMP_FIRST_NAME,' ','') as name
from EMP as p
where p.VALID_FLG = '1'
group by name
having count(*) >= 2
) 
order by REPLACE(e.EMP_LAST_NAME||e.EMP_FIRST_NAME,' ',''), e.EMP_CODE