The HAVING Clause
The HAVING clause follows the GROUP BY clause both in syntax (its position in the SELECT statement) and in the sequence of execution. HAVING is basically the same as WHERE, with the difference that HAVING works on group rows.
Topics include the following:
- HAVING Filters Group Rows
- Wrapping Up: the HAVING Clause
Author: Rudy Limeback