select case when t.shape.area-round(t.shape.area)>0 then t.shape.area-round(t.shape.area) else t.shape.area-round(t.shape.area)+1 end from zd t
SQL获取小数点后的数据
最新推荐文章于 2024-05-30 16:56:11 发布
select case when t.shape.area-round(t.shape.area)>0 then t.shape.area-round(t.shape.area) else t.shape.area-round(t.shape.area)+1 end from zd t