select 
    EMP_CODE as CODE,
    replace(EMP_KANA_NAME,'_','') as KANA_NAME
from EMP
order by
    EMP_CODE desc;