| 14.17.ROUND |
| 14.17.1. | ROUND(x, [y]) gets the result of rounding x an optional y decimal places. |
| 14.17.2. | ROUND column value |
| 14.17.3. | ROUND for negative value |
| 14.17.4. | ROUND may have a second argument to handle precision: means the distance to the right of the decimal point |
| 14.17.5. | The second argument of ROUND defaults to 0 |
| 14.17.6. | The second argument of ROUND, precision, may be negative, which means displacement to the left of the decimal point |
| 14.17.7. | ROUND(5.75) |
| 14.17.8. | ROUND(5.75, 1) |
| 14.17.9. | ROUND(5.75, -1) (2) |
|
| 14.17.10. | ROUND(345.678,2) ROUND(345.678,-1) ROUND(345.678,-2) |
| 14.17.11. | Demonstrates the ROUND function |
| 14.17.12. | round(sqrt(sal),2) |