保留两位小数点
SELECT ROUND(CAST(field1 AS DOUBLE)/field2, 2) * 100 FROM TB;
不保留
SELECT CAST(field1 AS FLOAT)/field2 * 100 FROM TB
然後再頁面顯示時再加上“%”
保留两位小数点
SELECT ROUND(CAST(field1 AS DOUBLE)/field2, 2) * 100 FROM TB;
不保留
SELECT CAST(field1 AS FLOAT)/field2 * 100 FROM TB
然後再頁面顯示時再加上“%”
转载于:https://www.cnblogs.com/MagicAsa/p/9856651.html