kpi sql 积累

kpi sql 积累

-- 2021-10-28 
update kpi_value_in set value = replace (value , E'%',''):: numeric / 100
where position ('%' in value) > 0 and value is not null;