话单分析 之 含小数保留9位

select dz,dzzw,lac,jzh,jzh4,jzm,bgi,cgi,
jind=case
    when round(jind,8)>=10 then round(jind,9)
    else round(jind*2,1)/2
end,

weid=case
    when round(weid,8)>=10 then round(weid,9)
    else round(weid*2,1)/2
    end
from bmjzx

 order by dz,jzh4 asc

*******

借鉴

把一个数值取到小数点后2位进行判断

case
    when round(hllsj,2)>=5 then round(hllsj,1)
    else round(hllsj*2,1)/2
end