select round(cast(字段名称 as numeric )/cast(字段名称 as numeric ),4) as yongshuju,round(cast(字段名称 as numeric )/cast(字段名称 as numeric ),4) as 参数名 from 数据表名称
round(cast(字段名称 as numeric )/cast(字段名称 as numeric ),4)
4表示保留4位小数
select round(cast(字段名称 as numeric )/cast(字段名称 as numeric ),4) as yongshuju,round(cast(字段名称 as numeric )/cast(字段名称 as numeric ),4) as 参数名 from 数据表名称
round(cast(字段名称 as numeric )/cast(字段名称 as numeric ),4)
4表示保留4位小数