SQL语句内做除法得出百分比

保留两位小数点

SELECT ROUND(CAST(field1 AS DOUBLE)/field2, 2) * 100 FROM TB;

不保留

SELECT CAST(field1 AS FLOAT)/field2 * 100 FROM TB

 

然後再頁面顯示時再加上“%”