Chapter 11. SELECT Statement: The HAVING Clause
11.1 Introduction
The purpose of the HAVING clause of a select block is comparable to that of the WHERE clause. The difference is that the WHERE clause is used to select rows after the FROM clause has been processed, whereas the HAVING clause is used to select rows after a GROUP BY clause has been executed. A HAVING clause can be used without a GROUP BY clause.
Definition
<having clause> ::= HAVING <condition>
In the previous chapter, you saw that the GROUP BY clause groups the rows of the result from the FROM clause. The HAVING clause enables you to select groups (with rows) based upon their ...
Get SQL for MySQL Developers: A Comprehensive Tutorial and Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
