ROUND 四舍五入(默认不保留小数位)
SCOTT@itkaifang> SELECT ROUND(987.654321) FROM dual; ROUND(987.654321) ----------------- 988 SCOTT@itkaifang> SELECT ROUND(987.654321,2) FROM dual; ROUND(987.654321,2) ------------------- 987.65 SCOTT@itkaifang> SELECT ROUND(987.654321,-2) FROM dual; ROUND(987.654321,-2) -------------------- 1000 SCOTT@itkaifang> SELECT ROUND(987.654321,-3) FROM dual; ROUND(987.654321,-3) -------------------- 1000 SCOTT@itkaifang> SELECT ROUND(987.654321,-1) FROM dual; ROUND(987.654321,-1) -------------------- 990 SCOTT@itkaifang>