select 
    EMP_CODE as CODE,
    TRIM(EMP_LAST_NAME,'') as SURNAME,
    TRIM(EMP_FIRST_NAME,'') as NAME
    from EMP
    where VALID_FLG = '1'
    order by SURNAME, CODE;