How do I retrieve decimals when rounding an average in SQL

May 30, 2023 by Tarik

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]