SqlServer教程

SQLServer AVG()

SQLServer AVG()函数用于返回表达式的平均值。
语法:
SELECT AVG(aggregate_expression)
FROM tables
[WHERE conditions];
示例:
选择"雇员"表并获取该表的平均工资。
SELECT AVG(salary) AS "Average Salary"
FROM Employees; 
输出:
SQL服务器平均功能1
昵称: 邮箱:
Copyright © 2022 立地货 All Rights Reserved.
备案号:京ICP备14037608号-4