四舍五入保留小数点后两位:ROUND(X,D) X:值 D:位数 eg: select ROUND(4545.1366,2); 结果:4545.14 注:https://blog.csdn.net/haojiahj/article/details/45790497