🎴 Flashcard Mode

Java Programming and SQL Basics

Card1 / 20
Mastered0
Review0
QuestionClick to flip

We can use Group functions in the WHERE clause

AnswerClick to flip back
A
False
💡 Explanation:

Standard SQL does not allow group (aggregate) functions like SUM, AVG, or COUNT directly in the WHERE clause because the WHERE clause filters rows before grouping occurs. To filter groups based on aggregate results, the HAVING clause must be used instead, making the statement false.

Change Mode