select
    CODE,
    SURNAME,
    NAME
from
    (
        select
            EMP_CODE as CODE,
            REPLACE(EMP_LAST_NAME, ' ', '') as SURNAME,
            REPLACE(EMP_FIRST_NAME, ' ', '') as NAME,
            count (*) as count
        from
            EMP
        group by
            REPLACE(EMP_LAST_NAME, ' ', ''),
            REPLACE(EMP_FIRST_NAME, ' ', '')
        having
            count (*) > 1
    )
order by
    SURNAME,
    NAME,
    CODE