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

FROM EMP

WHERE VALID_FLG = '1'
  AND REPLACE(EMP_LAST_NAME||EMP_FIRST_NAME,' ','') IN(
      SELECT
         REPLACE(EMP_LAST_NAME||EMP_FIRST_NAME,' ','') AS EMP_NAME
      FROM EMP
      WHERE VALID_FLG = '1'
      GROUP BY EMP_NAME
      
      HAVING  COUNT(*)>=2
      
      )
      ORDER BY REPLACE(EMP_LAST_NAME||EMP_FIRST_NAME,' ','') ASC,
          EMP_CODE ASC