Returns the average of the values in a group. Null values are ignored.
Syntax:
AVG ( expression )
Example:
SELECT AVG(VacationTime)AS 'Average vacation time in hours',
SUM(SickLeave) AS 'Total sick leave time in hours'
FROM HR.Employee
WHERE JobTitle LIKE 'Vice Admiral%'
Comments
Please sign in to leave a comment.