sql中计算百分比:(转成字符串然后拼接%)
SELECT CONCAT(CAST(round((3/21)*100,3) AS CHAR),'%') as aa from act_canal;
效果: