select emp.EMP_CODE as CODE,
emp.EMP_LAST_NAME as SURNAME,
emp.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, ' ','')
) as emp_cnt
inner join emp
on emp_cnt.cnt > 1
and replace(emp.emp_last_name, ' ','') || replace(emp.emp_first_name, ' ','') = emp_cnt.full_name
order by 
replace(emp.emp_last_name, ' ','') || replace(emp.emp_first_name, ' ',''),
emp.emp_code
;