Allows you to filter a recordset resulting from a GROUP BY clause.
Syntax:
HAVING expression
Example to get the totals by cache type (but only if at least 10 in total):
$status = dbtosql("caches","Code,Name,CacheType,Container,Difficulty,Terrain","$_Install\macros\caches.txt","") $status = sql("select CacheType, count(CacheType) as Total from caches Group By CacheType having total > 10","") $html = sqltohtml($status,"Cache Summary","Y") |
Notes
Any field that you want to use in HAVING, must also be included in the select clause.
You should be aware of the difference between the WHERE clause and the HAVING clause. The WHERE clause is applied to table(s) in the FROM clause. The HAVING is applied after filtering with WHERE and grouping with group by have been applied. The same applies to the ORDER BY clause which is also applied to the final result set.