tags:

views:

260

answers:

1
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?

+7  A: 

Try

Select
    AVG(Cast(variable as Float)),
    SUM(variable)
From
    Table
Chalkey
it works, thanks :)
NetSide
cool no worries :)
Chalkey