select
 e1.EMP_CODE as 'CODE'
 , e1.EMP_LAST_NAME as 'SURNAME'
 , e1.EMP_FIRST_NAME as 'NAME'
from
 EMP e1
 inner join EMP e2
 on e1.EMP_CODE = e2.EMP_CODE
where
 REPLACE(e1.EMP_LAST_NAME,' ','') = REPLACE(e2.EMP_LAST_NAME,' ','')
 and REPLACE(e1.EMP_FIRST_NAME,' ','') = REPLACE(e2.EMP_FIRST_NAME,' ','')
 and e1.VALID_FLG = '1'
order by 
 e1.EMP_FIRST_NAME asc 
 , e1.EMP_FIRST_NAME asc
 , e1.EMP_CODE asc
;