round函数
SQL> select round(1.6) from dual;ROUND(1.6)
----------
2SQL> select round(1.4) from dual;ROUND(1.4)
----------
1
SQL> select round(1.6) from dual;ROUND(1.6)
----------
2SQL> select round(1.4) from dual;ROUND(1.4)
----------
1
SQL> select round(1.425,2) from dual
2 /ROUND(1.425,2)
--------------
1.43
SQL> select round(1.424,2) from dual;ROUND(1.424,2)
--------------
1.42
ROUND(值,位数)
多给你加分