本文共 397 字，大约阅读时间需要 1 分钟。

round(cast(hospital_area as numeric) / cast(all_area as numeric) * 100,6)结果乘100，取6位小数，结果展示

select *,round(cast(hospital_area as numeric) / cast(all_area as numeric) * 100,6) as hospital_ratio_new,round(cast(food_area as numeric) / cast(all_area as numeric) * 100,2) as food_tatio_new from area_relation_scenes

cast函数，将某个字段转成某种类型

例如：cast(hospital_area as numeric) 将hospital_area(原本是字符串的)转成numeric类型