/*
select EMP_CODE as CODE, EMP_LAST_NAME as SURNAME, EMP_FIRST_NAME as NAME
from EMP
where EMP_FIRST_NAME = 
*/

-- select replace(EMP_LAST_NAME, ' ', '') from EMP;

select EMP_CODE as CODE, EMP_LAST_NAME as SURNAME, EMP_FIRST_NAME as NAME
from EMP
where VALID_FLG = '1'
    AND replace(EMP_FIRST_NAME || EMP_LAST_NAME, ' ', '') IN (
        select replace(EMP_FIRST_NAME || EMP_LAST_NAME, ' ', '') as EMP_NAME
        from EMP
        where VALID_FLG = '1'
        group by EMP_NAME
        having COUNT(*) >= 2
        )
order by replace(EMP_FIRST_NAME || EMP_LAST_NAME, ' ', '') asc, EMP_CODE