Multiple choice technology databases

We can use Group functions in the WHERE clause

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Group functions (aggregate functions) cannot be used in the WHERE clause because WHERE operates on individual rows before grouping. To filter based on aggregate values, you must use HAVING after the GROUP BY clause. This is a fundamental SQL execution order rule.

Keep practicing — related questions