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?
Just columns listed in the aggregate count.
Only columns listed in the aggregate count or in the Group By clause.
Any column in your table.
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement