select emp_code as CODE,emp_last_name as SURNAME,emp_first_name as NAME
from (
    select *, replace(emp_last_name,' ','')||' '||replace(emp_first_name,' ','') as nm
    from EMP
    where VALID_FLG=1
)
where nm in (
        with t as (
            select *, replace(emp_last_name,' ','')||' '||replace(emp_first_name,' ','') as z
            from EMP
            where VALID_FLG=1
        )
        select z
        from t
        group by z having count(z) >1
)
order by nm, emp_code;