Multiple choice technology databases

which of these can be used to filter aggregate functions?

  1. WHEN

  2. HAVING

  3. WHERE

  4. ANY

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

HAVING filters aggregate functions after grouping. WHERE filters rows before aggregation and cannot use aggregate functions. WHEN is used in CASE expressions, and ANY is a comparison operator.