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 SURNAME,NAME,EMP_CODE;