sql之Sql中的AVG之float 问题

SELECT     AVG(variable) AS Expr1, SUM(variable) AS Expr2 
FROM       ...... 

请您参考如下方法:

尝试

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