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