select EMP_CODE as CODE,
EMP_LAST_NAME as SURNAME,
EMP_FIRST_NAME as NAME from 
(
select count(replace(emp.emp_last_name, ' ','') || replace(emp.emp_first_name, ' ','')) as cnt ,replace(emp.emp_last_name, ' ','') || replace(emp.emp_first_name, ' ','') as full_name
, emp.emp_code, emp.emp_last_name, emp.emp_first_name from emp
where emp.valid_flg = 1
group by replace(emp.emp_last_name, ' ','') || replace(emp.emp_first_name, ' ','')
)
where cnt > 1
;