Learn
Conditional Aggregates
Generalizations
Congratulations! You just learned about Conditional Aggregates in SQL. What can we generalize so far?
- Conditional Aggregates are aggregate functions the compute a result set based on a given set of conditions.
NULL
can be used to denote an empty field valueCASE
statements allow for custom classification of dataCASE
statements can be used inside aggregates (likeSUM()
andCOUNT()
) to provide filtered measures