sqlaverage

AVG in Sql - Float number 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?


Solution

  • Try

    Select
        AVG(Cast(variable as Float)),
        SUM(variable)
    From
        Table