| |
| 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) |
|