Home » Fashion Innovations Express » Avg in Sql - Float Number Problem

Avg in Sql - Float Number Problem

David Miller • • 1 min read
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?

1

1 Answer

Try

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

David Miller
Author

David Miller

David Miller brings 15 years of experience in global economics, personal finance strategy, and market dynamics. He specializes in turning complex economic trends into actionable insights for everyday readers.