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 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," ","")) ORDER BY  replace(A.EMP_LAST_NAME," ",""),replace(A.EMP_FIRST_NAME," ",""),EMP_CODE;