sql avg函数使用格式
什么是SQL平均(AVG)函数? (What is the SQL Average (AVG) Function?)
“Average” is an Aggregate (Group By) Function. It’s used to calculate the average of a numeric column from the set of rows returned by a SQL statement.
“平均”是汇总(分组依据)函数。 它用于从SQL语句返回的行集中计算数字列的平均值。
Here is the syntax for using the function:
这是使用该函数的语法:
select groupingField, avg(num_field)
from table1
group by groupingField
Here’s an example using the student table:
这是使用学生表的示例:
select studentID, FullName, avg(sat_score)
from student
group by studentID, FullName;
翻译自: https://www.freecodecamp.org/news/sql-avg-average-function/
sql avg函数使用格式