sql中计算百分比:(转成字符串然后拼接%)
SELECT CONCAT(CAST(round((3/21)*100,3) AS CHAR),'%') as aa from act_canal;
效果:
sql中计算百分比:(转成字符串然后拼接%)
SELECT CONCAT(CAST(round((3/21)*100,3) AS CHAR),'%') as aa from act_canal;
效果:
转载于:https://www.cnblogs.com/super-chao/p/8892232.html