ROUND()函数
SELECT
ROUND(789.567) 不保留小数四舍五入,
ROUND(789.567,2) 保留两位小数四舍五入,
ROUND(789.567,-2) 处理整数进位四舍五入
FROM dual;
789 789.56 700
TRUNC()函数
SELECT
TRUNC(789.567) 截取小数,
TRUNC(789.567,2) 截取两位小数,
TRUNC(789.567,-2) 取整
FROM dual;
789 789.56 700
MOD()取模函数
selsect mod(10,3) from dual;
1