(1) select concat(convert(convert(1/2,decimal(4,2))*100,char),'%') as dskfa
(2)select case aa when 0.00 then 'null' else aa end aa from 表
(1) select concat(convert(convert(1/2,decimal(4,2))*100,char),'%') as dskfa
(2)select case aa when 0.00 then 'null' else aa end aa from 表