🎴 Flashcard Mode
SQL Fundamentals: DML, Aggregates, and Group Operations
Card1 / 20
Mastered0
Review0
QuestionClick to flip
We can use Group functions in the WHERE clause
AnswerClick to flip back
A
False
💡 Explanation:
Group functions (aggregate functions like COUNT, SUM, AVG, MAX, MIN) cannot be used in WHERE clause. WHERE filters individual rows before grouping. Group functions must be used in HAVING clause or SELECT list, after grouping has occurred. This is a fundamental SQL rule.