SELECT A.EMP_CODE AS CODE,
replace(A.EMP_LAST_NAME,"","") AS SURNAME,
replace(A.EMP_FIRST_NAME,"","") AS NAME FROM EMP AS A WHERE A.VALID_FLG == 1 AND EXISTS (SELECT * FROM EMP AS B WHERE A.EMP_CODE != B.EMP_CODE AND replace(A.EMP_LAST_NAME," ","") == replace(B.EMP_LAST_NAME," ","") AND replace(A.EMP_FIRST_NAME," ","") == replace(B.EMP_FIRST_NAME," ","") AND B.VALID_FLG = 1) ORDER BY  replace(A.EMP_LAST_NAME," ",""),replace(A.EMP_FIRST_NAME," ",""),EMP_CODE;