you are at Encyclopedia of SQL >> ROUND()
ROUND(`column_name`,digits_after_comma)
It rounds given value with specified precision.Syntax
SELECT ROUND(`column_name`,digits_after_comma)
FROM `table_name`
Example
Display rate of exchange with two digits after comma precision
| currency | exchange rate |
|---|---|
| USD | 3,456352 |
| EUR | 4,342135 |
| CHF | 3,124424 |
query
SELECT `currency`,ROUND(`exchange_rate`,2)
AS er
FROM `people`
result
| currency | exchange rate |
|---|---|
| USD | 3,46 |
| EUR | 4,34 |
| CHF | 3,12 |
