sql实现小数位小于0.25舍弃,0.25-0.75等于0.5,大于0.75进1
select
case when 232*0.05 %1 <0.25 then floor(232*0.05)
when 232*0.05 %1 >0.75 then ceil(232*0.05)
else floor(232*0.05)+0.5 end
sql实现小数位小于0.25舍弃,0.25-0.75等于0.5,大于0.75进1
select
case when 232*0.05 %1 <0.25 then floor(232*0.05)
when 232*0.05 %1 >0.75 then ceil(232*0.05)
else floor(232*0.05)+0.5 end