CASE WHEN a.STRAND_5 !=0 THEN
concat(to_char(CAST(CAST(b.STRAND_5 as FLOAT)/a.STRAND_5 *100 as numeric(10,2))),’%’)
ELSE
‘0.00%’
END as STRAND_5Perce,
在数据库中,求百分比,但是去出现了遇到被零除错误
最新推荐文章于 2022-03-02 19:56:34 发布
CASE WHEN a.STRAND_5 !=0 THEN
concat(to_char(CAST(CAST(b.STRAND_5 as FLOAT)/a.STRAND_5 *100 as numeric(10,2))),’%’)
ELSE
‘0.00%’
END as STRAND_5Perce,