ROUND « Math Functions « SQL Server / T-SQL
- SQL Server / T-SQL
- Math Functions
- ROUND
1. | ROUND: Rounds a value to the number of decimal places specified in the second parameter | | |
2. | Round the updated data | | |
3. | ROUND(107.345678,-1,0) | | |
4. | ROUND(100.345678,5,1) | | |
5. | select ROUND(12.5,0) | | |
6. | select ROUND(12.4999,0) | | |
7. | select ROUND(12.4999,1) | | |
8. | select ROUND(12.4999,-1) (minus) | | |
9. | select ROUND(12.5,0,1) | | |
|