select (cast (trim('%' from schedule1) as float) -cast (trim('%' from expsche1) as float))||'%' as deviation1 from mon_completion
备注:schedule1,expsche1是字段,填入为字符串格式
trim(‘%’ from 字段名)是将带百分号删除【第二种方法:replace(字段名,‘%’,'')】
cast(字段名 as float)是将字段转化成数字格式