Having conditions
This row is available if "Group by" is required; when one or more columns use one of the following functions: count, min, max, average, sum.
Having Conditions function like other query conditions, except that they have an additional
aggregation function field. Their format is: <And/Or> <field> <aggregation function >
<operator> <value/parameter/group> <value>. The aggregation function can have the values:
- Count
- Min
- Max
- Avg.
- Having
The operators available in the Having clause are:
- Smaller than (<)
- Smaller than or equal to (<=)
- Not equal to (<>)
- Equal to (=)
- Greater than (>)
- Greater than or equal to (>=)