select distinct
EMP_CODE as CODE,
EMP_LAST_NAME as SURNAME,
EMP_FIRST_NAME as NAME
from EMP as TBLA
inner join 
(
    select
        replace(EMP_LAST_NAME,' ','') as RE_EMP_LAST_NAME,
        replace(EMP_FIRST_NAME,' ','') as RE_EMP_FIRST_NAME,
        count(EMP_CODE) as re_count
    from
        EMP
    where
        VALID_FLG = '1'
    group by
        RE_EMP_LAST_NAME,RE_EMP_FIRST_NAME
    having
        re_count > 1
) as TBLB
order by 
RE_EMP_FIRST_NAME asc,
RE_EMP_LAST_NAME asc,
EMP_CODE asc