SQL 小数点转换百分号 小于1的数字用tochar方法,否则前面零消失
concat(to_char(CAST( CAST(b.SUM_W as FLOAT)/a.SUM_W *100 as numeric(10,2))),’%’) as “SUM_WPerce”
SQL 小数点转换百分号 小于1的数字用tochar方法,否则前面零消失
concat(to_char(CAST( CAST(b.SUM_W as FLOAT)/a.SUM_W *100 as numeric(10,2))),’%’) as “SUM_WPerce”