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 SURNAME_NAME
FROM
    EMP
WHERE 
    VALID_FLG = '1'
GROUP BY
    SURNAME_NAME
HAVING
    COUNT(*) >= 2
)
ORDER BY
    REPLACE(SURNAME || NAME,' ','') ASC
    ,CODE ASC;