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,' ','') || replace(emp_first_name,' ','') 
in (
select 
replace(emp_last_name,' ','') || replace(emp_first_name,' ','') as a
from emp
where valid_flg = '1'
group by
a
having count(*) >=2
)
order by
replace(SURNAME,' ','') || replace(NAME,' ','') asc,
CODE asc
;