或者说在sql查询时加入单位万元
SELECT
sum(nonoil_income)/10000 as "收入"
FROM app_csrq_fy_hy
怎么加呢?
to_char(sum(nonoil_income)/10000)||'万元' as "收入"
'万元' as "单位"
选择一个格式后手动在后面写上单位。
效果图: