mysql - "Missing closing parenthesis"MySQL错误

Question

我正在尝试运行一个查询，将四舍五入的平均值显示到小数点后两位。这是我的代码，我不知道为什么我一直收到错误。

SELECT 
    ROUND(AVG (Scholarship, 2)) AS 'Average Scholarships'
FROM
    student;

Answer 1

您正在将 Scholarship, 2 传递给 AVG 函数，该函数只需要一个参数。

你想做的是将 AVG (Scholarship) 和 2 传递给 ROUND，如下所示:

SELECT ROUND(AVG (Scholarship), 2) AS 'Average Scholarships' FROM student;