HAVING Clause (SQL Only)

See AlsovbhowSQLHAVINGSee                 ExamplevbhowSQLHAVINGEx>Low

Description

Use HAVING to specify which grouped records are displayed.  Once GROUP BY combines records, HAVING displays all records grouped by the GROUP BY clause that satisfy the conditions of the HAVING clause.

Notes

         HAVING is optional but when included follows GROUP BY.

         HAVING is similar to WHERE.  WHERE determines which records are selected.  Once records are grouped with GROUP BY, HAVING determines which records are displayed.

         Use various expressions to determine which records are displayed.