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) || trim(A.EMP_FIRST_NAME) asc ,A.EMP_CODE asc