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