SELECT 
emp1.EMP_CODE AS CODE,
emp1.EMP_LAST_NAME AS SURNAME,
emp1.EMP_FIRST_NAME AS NAME
FROM EMP emp1
WHERE EXISTS(
 SELECT 1
 FROM EMP emp2
 WHERE REPLACE(emp1.EMP_CODE, ' ', '') != REPLACE(emp2.EMP_CODE, ' ', '') 
 AND REPLACE(emp1.EMP_LAST_NAME, ' ', '') = REPLACE(emp2.EMP_LAST_NAME, ' ', '')
 AND REPLACE(emp1.EMP_FIRST_NAME, ' ', '') = REPLACE(emp2.EMP_FIRST_NAME, ' ', '')
 AND emp2.VALID_FLG = '1'
) AND emp1.VALID_FLG = '1'
ORDER BY 
REPLACE(emp1.EMP_LAST_NAME, ' ', '') ASC, 
REPLACE(emp1.EMP_FIRST_NAME, ' ', '') ASC,
emp1.EMP_CODE