SELECT
    EMP_CODE as 'CODE',
    EMP_LAST_NAME as 'SURNAME',
    EMP_FIRST_NAME as 'NAME'
FROM EMP
WHERE
    VALID_FLG = '1' AND
    (SELECT COUNT(*) FROM EMP AS EMP_B
    WHERE
        REPLACE(EMP.EMP_LAST_NAME, ' ', '') = REPLACE(EMP_B.EMP_LAST_NAME, ' ', '') AND
        REPLACE(EMP.EMP_FIRST_NAME, ' ', '') = REPLACE(EMP_B.EMP_FIRST_NAME, ' ', '') AND
        EMP_B.VALID_FLG = '1')
        >= 2
ORDER BY
REPLACE(EMP_FIRST_NAME, ' ', ''),
REPLACE(EMP_LAST_NAME, ' ', ''),
EMP_CODE