select
    TBLA.EMP_CODE as CODE,
    TBLB.EMP_LAST_NAME as SURNAME,
    TBLB.EMP_FIRST_NAME as NAME
from
    (
    select
        EMP_CODE,
        replace(EMP_LAST_NAME,' ','') as EMP_LAST_NAME,
        replace(EMP_FIRST_NAME,' ','') as EMP_FIRST_NAME,
        count(EMP_CODE) as count
    from
        EMP
    where
        VALID_FLG = '1'
    group by
        EMP_LAST_NAME,EMP_FIRST_NAME
    ) as TBLA
left outer join
    EMP as TBLB on TBLA.EMP_CODE = TBLB.EMP_CODE
where
    count >= 1
order by
    TBLA.EMP_FIRST_NAME asc,
    TBLA.EMP_LAST_NAME asc,
    TBLA.EMP_CODE asc