select 
CODE, 
SURNAME,
NAME
FROM (select 
E.EMP_CODE as CODE,
E.EMP_LAST_NAME as SURNAME,
E.EMP_FIRST_NAME as NAME,
replace(E.EMP_LAST_NAME || E.EMP_FIRST_NAME, ' ', '') as FULLNAME
FROM EMP E
WHERE VALID_FLG='1'
AND replace(E.EMP_LAST_NAME || E.EMP_FIRST_NAME, ' ', '') IN (
    select NAME FROM (select NAME, count(NAME) as CNT FROM (select replace(EMP_LAST_NAME || EMP_FIRST_NAME, ' ', '') as NAME from EMP WHERE VALID_FLG='1') EMP1 group by NAME) CNTNAME WHERE CNT>=2
) )
order by 
FULLNAME asc,
CODE asc;