AVG in Sql - Float number problem
average, sql
Solution
Try
Select
AVG(Cast(variable as Float)),
SUM(variable)
From
Table
Problem
``` SELECT AVG(variable) AS Expr1, SUM(variable) AS Expr2 FROM ...... ``` result for AVG is 2, but it is not true, it must be 2.95. What is the problem, any idea?