SQL:? select round(788.6) from dual;? //不指定時白筹,默認小數(shù)點后第一位開始四舍五入
RESULT: 789
-------------------------------------------------
SQL:? select round(788.6,-1) from dual; //指定整數(shù)位開始四舍五入
RESULT: 790
-------------------------------------------------
SQL:? select round(788.446, 2) from dual; //指定保留的小數(shù)位數(shù),四舍五入
RESULT: 788.45
SQL:? select round(788.441, 2) from dual; //指定保留的小數(shù)位數(shù),四舍五入
RESULT: 788.44