AVG
Last updated
Last updated
This function returns the average of the values in a group. It ignores null values. (AVG in Transact-SQL).
AVG ( [ ALL | DISTINCT ] expression )
[ OVER ( [ partition_by_clause ] order_by_clause ) ]
Code:
SELECT AVG(VACATIONHOURS) AS AVG_VACATIONS FROM HUMANRESOURCES.EMPLOYEE;
Result:
AVG_VACATIONS|
-------------+
50|