SELECT EMP_CODE AS CODE, 
       TRIM(REPLACE(EMP_LAST_NAME, ' ', '')) AS SURNAME, 
       TRIM(REPLACE(EMP_FIRST_NAME, ' ', '')) AS NAME
FROM EMP
WHERE VALID_FLG = '1'
  AND CONCAT(TRIM(REPLACE(EMP_LAST_NAME, ' ', '')), TRIM(REPLACE(EMP_FIRST_NAME, ' ', '')))
      IN (
        SELECT CONCAT(TRIM(REPLACE(EMP_LAST_NAME, ' ', '')), TRIM(REPLACE(EMP_FIRST_NAME, ' ', '')))
        FROM EMP
        WHERE VALID_FLG = '1'
        GROUP BY CONCAT(TRIM(REPLACE(EMP_LAST_NAME, ' ', '')), TRIM(REPLACE(EMP_FIRST_NAME, ' ', '')))
        HAVING COUNT(*) > 1
      )
ORDER BY SURNAME, NAME, EMP_CODE;