- 可以使用 转换函数:to_char(‘0.32’,’fm9999990.00’)
如一个转诊率的sql
Select ROUND(sum(zztj) / sum(outHosPers), 4) * 100 as zzl from a
修改sql
Select to_char(ROUND(sum(zztj) / sum(outHosPers), 4) * 100,’fm9999990.00’)as zzl from a
如一个转诊率的sql
Select ROUND(sum(zztj) / sum(outHosPers), 4) * 100 as zzl from a
修改sql
Select to_char(ROUND(sum(zztj) / sum(outHosPers), 4) * 100,’fm9999990.00’)as zzl from a