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;