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