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