SELECT
    EMP_CODE
    , REPLACE (EMP_NAME, ' ', '') AS EMP_NAME
FROM
    TBL_EMPLOYEES
ORDER BY
    EMP_CODE DESC;