select 
a.EMP_CODE as CODE
,TRIM(a.EMP_LAST_NAME) as SURNAME
,TRIM(a.EMP_FIRST_NAME) as  NAME
from 
(
    select *
    from EMP
    where VALID_FLG='1'
) a
INNER JOIN
(
    select *
    from EMP
    where VALID_FLG='1'
) b
ON
TRIM(a.EMP_LAST_NAME)=TRIM(b.EMP_LAST_NAME)
and TRIM(a.EMP_FIRST_NAME)=TRIM(b.EMP_FIRST_NAME)
order by 
REPLACE(a.EMP_LAST_NAME||a.EMP_FIRST_NAME,' ','')
,a.EMP_CODE