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(*) >= 2
   )
ORDER BY
    REPLACE (EMP_LAST_NAME || EMP_FIRST_NAME, ' ', '') ASC,
    EMP_CODE ASC;