SELECT EMP_CODE AS CODE,
       EMP_LAST_NAME AS SURNAME,
       EMP_FIRST_NAME AS NAME
FROM EMP

WHERE VALID_FLG = 1 AND EMP_ENG_NAME IN (SELECT EMP_ENG_NAME FROM EMP GROUP BY EMP_ENG_NAME HAVING COUNT(*) > 1)
ORDER BY REPLACE(EMP_LAST_NAME,' ',''),
         REPLACE(EMP_FIRST_NAME,' ',''),
         CODE;