Havingpredicate
The HAVING clause is similar to the
WHERE
clause. However, you can also test groups by using the group (or column) functions below:
Function
Meaning
SUM(field)
The sum of field taken over the group
AVG(field)
The average of field taken over the group
MAX(expression)
The maximum value of expression
MIN(expression)
The minimum value of expression
[
Return to SQL Syntax
]