About this document
Understanding SQL HAVING Clause by shen shen is a document available to read on EtoBox.
The HAVING clause allows SQL SELECT statements to filter group rows based on aggregate functions. It was added to SQL because the WHERE clause cannot be used with aggregate functions. The HAVING clause filters at the group level after the GROUP BY clause has grouped the rows. It is used to view conditions formed by the GROUP BY clause and return groups where aggregate values meet specified conditions.
- Author
- shen shen
- Language
- EN