select
    CODE,SURNAME,NAME
from(
        select
            EMP_CODE as CODE,
            REPLACE(EMP_LAST_NAME,' ','')as SURNAME,
            REPLACE(EMP_FIRST_NAME,' ','')as NAME
        from
            EMP 
        where
            VALID_FLG = '1'
    ) a
where
    CODE in (10004,10006,10009,10010)
order by
    SURNAME,CODE