sql 除法 除数为零
select decode(zzc,0,0,fz/zzc) from table
BigDecimal的devide的函数定义如下
BigDecimal.divide(BigDecimal divisor, int scale, RoundingMode roundingMode) ;
scale为小数位数;
roundingMode为小数模式;
ROUND_CEILINGsql 除法 除数为零
select decode(zzc,0,0,fz/zzc) from table
BigDecimal的devide的函数定义如下
BigDecimal.divide(BigDecimal divisor, int scale, RoundingMode roundingMode) ;
scale为小数位数;
roundingMode为小数模式;
ROUND_CEILING