sql server - How do I retrieve decimals when rounding an average in SQL

Question

Here is my SQL statement

SELECT ROUND(AVG(column_name), 100) 
FROM [database].[dbo].[table]

The answer I retrieve is 3 with a possible range of numbers between 1 - 5 in 908 rows.

I need it to say 3.0 or 3.09. Is this possible?

question from:https://stackoverflow.com/questions/13237477/how-do-i-retrieve-decimals-when-rounding-an-average-in-sql

Answer 1

The average will have the same data type as the values, so cast the values:

SELECT ROUND(AVG(CAST(column_name AS FLOAT)), 2) FROM [database].[dbo].[table]