Back to lesson
1. When do we use the Having Clause?
When we want to search within a "Group By" Aggregate result.
When we want to search deeper.
When you want to see if a thing has a thing.
2. Can we use the Where clause with a "Group By"?
No, you need to use the Having Clause.
3. What Columns can we search by using the Having clause?
Any column in your table.
Just columns listed in the aggregate count.
Only columns listed in the aggregate count or in the Group By clause.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement