select
    EMP_CODE,
    replace(EMP_NAME, ' ', '') as EMP_NAME
from TBL_EMPLOYEES
order by EMP_CODE desc
;