SELECT
    EMP_CODE AS CODE
    ,EMP_LAST_NAME AS SURNAME
    ,EMP_FIRST_NAME AS NAME
FROM EMP
WHERE VALID_FLG = '1'
AND REPLACE(EMP.EMP_LAST_NAME || EMP.EMP_FIRST_NAME, ' ', '') IN (
    SELECT
        REPLACE(EMP.EMP_LAST_NAME || EMP.EMP_FIRST_NAME, ' ', '') AS EMP_NAME
    FROM EMP
    WHERE VALID_FLG = '1'
    GROUP BY EMP_NAME
    HAVING COUNT(*) > 1
    )
ORDER BY
    REPLACE(EMP.EMP_LAST_NAME || EMP.EMP_FIRST_NAME, ' ', '') ASC
    ,EMP_CODE ASC