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



Visit Website

Code Archive

Sample Applications & Examples

Simply SQL

Publisher: SitePoint

Author: Rudy Limeback

Year: 2008