SELECT
a.EMP_CODE AS CODE,
a.EMP_LAST_NAME AS SURNAME,
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 replace(SURNAME || NAME,' ','') ASC,CODE ASC