We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
SQL Server
The problem here is that AVG() returns an integer when used on integers. So the result will be wrong. You have to convert the values to float before using AVG().
This worked for me:
The Blunder
You are viewing a single comment's thread. Return to all comments →
SQL Server The problem here is that
AVG()
returns an integer when used on integers. So the result will be wrong. You have to convert the values to float before usingAVG()
. This worked for me: