SELECT EMP_CODE AS CODE,
       EMP_LAST_NAME AS SURNAME,
       EMP_FIRST_NAME AS NAME
        from EMP
            where where VALID_FLG = '1' and replace(EMP_LAST_NAME || EMP_FIRST_NAME ,' ','') in (
    select 
        replace(EMP_LAST_NAME || EMP_FIRST_NAME,' ','') as NAME
    from EMP 
         where 
            VALID_FLG = '1' 
    group by 
        NAME
    having 
        count(*) > 1)
order by
    replace(EMP_LAST_NAME || EMP_FIRST_NAME ,' ','') asc,
    EMP_CODE asc;