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 ) ]AVG( [ DISTINCT ] <expr1> )
AVG( [ DISTINCT ] <expr1> ) OVER (
[ PARTITION BY <expr2> ]
[ ORDER BY <expr3> [ ASC | DESC ] [ <window_frame> ] ]
)Examples
Code:
SELECT AVG(VACATIONHOURS) AS AVG_VACATIONS FROM HUMANRESOURCES.EMPLOYEE;Result:
AVG_VACATIONS|
-------------+
50|Code:
SELECT AVG(VACATIONHOURS) AS AVG_VACATIONS FROM HUMANRESOURCES.EMPLOYEE;Result:
AVG_VACATIONS|
-------------+
50.613793|Last updated
Was this helpful?