oracle round 没有0,oracle round函数的使用方法

最新推荐文章于 2024-09-03 18:03:53 发布

奶油肥皂

最新推荐文章于 2024-09-03 18:03:53 发布

阅读量1.3k

点赞数

SQL round函数数值处理四舍五入精度控制

关键词由CSDN通过智能技术生成

round(input_value,decimal_places_of_precision),例如： SQL> select round(1234.5678,4) from dual; ROUND(1234.5678,4) ------------------ 1234.5678 SQL> select round(1234.5678,3) from dual; ROUND(1234.5678,3) ------------------ 1234.568 SQL> select round(1234.5678,2) from dual; ROUND(1234.5678,2) ------------------ 1234.57 SQL> select round(1234.5678,1) from dual; ROUND(1234.5678,1) ------------------ 1234.6 SQL> select round(1234.5678,0) from dual; ROUND(1234.5678,0) ------------------ 1235 SQL> select round(1234.5678,-1) from dual; ROUND(1234.5678,-1) ------------------- 1230 SQL> select round(1234.5678,-2) from dual; ROUND(1234.5678,-2) ------------------- 1200 SQL> select round(1234.5678,-3) from dual; ROUND(1234.5678,-3) ------------------- 1000