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,
08-04
437
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
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,