SELECT
    EMP_CODE as CODE,
    REPLACE(EMP_KANA_NAME, '_', '')  as KANA_NAME
FROM
    EMP
order by
    EMP_CODE desc
;