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