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