1、ROUND四舍五入,如下结果保留小数点后面三位,为3.142 SELECT ROUND(3.1415,3) FROM dual; 2、TRUNC截取,如下结果截取小数点后面三位,为3.141 SELECT TRUNC(3.1415,3) FROM DUAL; 3、MOD取余,以下结果为1 SELECT MOD(5,2) FROM DUAL;