select A.EMP_CODE as CODE
    , A.EMP_LAST_NAME as SURNAME
    , A.EMP_FIRST_NAME as NAME
    
from EMP as A 
    inner join EMP as B on trim(A.EMP_LAST_NAME) = trim(B.EMP_LAST_NAME) and  trim(A.EMP_FIRST_NAME) = trim (B.EMP_FIRST_NAME)
    
where A.VALID_FLG = '1' and B.VALID_FLG = '1'
order by trim(A.EMP_LAST_NAME || A.EMP_FIRST_NAME) asc ,A.EMP_CODE asc