Ravindra BagaleCourses & study guides Track your progress

HAVING: Filter Groups After Aggregates

By Last updated:

Lessons in this chapter:

  1. 13.1 WHERE vs HAVING in One Picture
  2. 13.2 How to Keep Groups with HAVING SUM(amount) Above a Target
  3. 13.3 How to Combine WHERE (Row Filter) and HAVING (Group Filter)
  4. 13.4 Practice: Branches Above Target and Busy Accounts Only

Quiz for this chapter is available on the Learn tracker after deploy.

Ravindra Bagale's Tip

Finish every lesson example in DB Browser before the quiz.

Ravi Sir's Cards for this chapter

HAVING: filter groups after totals. Managers ask for groups that pass a target, such as branches above their monthly goal.Revision cardWhat is the difference between WHERE and HAVING? WHERE works on single rows before grouping. HAVING works on groups after the totals are calculated.Interview cardWHERE vs HAVING. WHERE filters individual transactions before grouping. The query below uses HAVING to keep account groups after counting.Comparison card

All cards for this chapter