Ravindra BagaleCourses & study guides Track your progress

HAVING: Filter Groups After Aggregates — Ravi Sir's Cards

All SQL cards

Revision cards

HAVING: filter groups after totals. Managers ask for groups that pass a target, such as branches above their monthly goal.
HAVING: filter groups after totals · PNG

Interview cards

What is the difference between WHERE and HAVING? WHERE works on single rows before grouping. HAVING works on groups after the totals are calculated.
What is the difference between WHERE and HAVING? · PNG

Comparison cards

WHERE vs HAVING. WHERE filters individual transactions before grouping. The query below uses HAVING to keep account groups after counting.
WHERE vs HAVING · PNG