SELECT
    distinct 
    t1.EMP_CODE as CODE
    ,t1.EMP_LAST_NAME as SURNAME
    ,t1.EMP_FIRST_NAME as NAME
FROM
    EMP t1
inner join EMP t2 on
replace(t1.EMP_LAST_NAME,' ','')||replace(t1.EMP_FIRST_NAME,' ','')
=replace(t2.EMP_LAST_NAME,' ','')||replace(t2.EMP_FIRST_NAME,' ','')
and t2.VALID_FLG = '1'

WHERE
    t1.VALID_FLG = '1'

ORDER BY 
    replace(t1.EMP_LAST_NAME,' ','')||replace(t1.EMP_FIRST_NAME,' ','') asc
    ,t1.EMP_CODE asc