Collections:
ROUND() - Rounding Values to Specific Precisions in SQL Server
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL?
✍: FYIcenter.com
Sometimes you need to round a numeric value to a specific precision. For example, you may want to round values in your financial statement to the precision of 1000.00. This can be done by the ROUND() function with the following syntax:
ROUND(value, precision, type) value: The input value to be rounded. precision: The location of the precision digit relative to the decimal point. type: 0 - Round to nearest value; 1 - Truncate to a lower value.
The tutorial exercise below gives some good examples of how to use the ROUND() function:
SELECT ROUND(1234.5678, 0, 0); SELECT ROUND(1234.5678, -3, 0); SELECT ROUND(1234.5678, -4, 0); SELECT ROUND(1234.5678, 3, 0); SELECT ROUND(1234.5678, 3, 1); GO 1235.0000 1000.0000 0.0000 1234.5680 1234.5670
⇒Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-11, 1975👍, 0💬
Popular Posts:
How To Create a Table in a Specific Tablespace in Oracle? After you have created a new tablespace, y...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Execute a Stored Procedure in SQL Server Transact-SQL? If you want execute a stored procedure...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server? Process mscorsvw.exe i...