mysql - 计算不带小数的平均值

Question

我希望我能解决这个问题。我需要制作一个平均值为 AVG_AMT(整数)且没有小数的表格。它可以舍入或截断。这对这张 table 来说真的无关紧要。

这是我试图写的:

SELECT `TC Code`, AVG(ALW_AMT) as int(8,0) AS AVG_AMT
FROM OFFICE_Claims_Physicians
GROUP BY `TC Code`
ORDER BY `TC Code`;

有什么建议吗？

Answer 1

SELECT 
    `TC Code`, 
    round(AVG(ALW_AMT),0) AS AVG_AMT
FROM 
    OFFICE_Claims_Physicians
GROUP BY 
    `TC Code`
ORDER BY 
    `TC Code`;