此函數(shù)返回X四舍五入到最接近的整數(shù)。如果第二個參數(shù)D提供,則函數(shù)返回x四舍五入至小數(shù)點后D位。 D必須為正數(shù)或全部在小數(shù)點右側(cè)的位將被刪除??紤]下面的例子:
SQL>SELECT ROUND(5.693893); +---------------------------------------------------------+ | ROUND(5.693893) | +---------------------------------------------------------+ | 6 | +---------------------------------------------------------+ 1 row in set (0.00 sec) SQL>SELECT ROUND(5.693893,2); +---------------------------------------------------------+ | ROUND(5.693893,2) | +---------------------------------------------------------+ | 5.69 | +---------------------------------------------------------+ 1 row in set (0.00 sec)