Examveda

Usage of aggregates in WHERE clause is allowed.

A. True

B. False

Answer: Option B

Solution (By Examveda Team)

This question is about using aggregate functions in the WHERE clause of a MySQL query.
Aggregate functions, like SUM, AVG, MAX, MIN, and COUNT, are used to calculate values from a group of rows.
However, in MySQL, you cannot use aggregate functions directly in the WHERE clause.
Let's break it down:
- WHERE clause filters rows based on individual row values.
- Aggregate functions calculate values across multiple rows.
Therefore, MySQL evaluates the WHERE clause before any aggregate functions are calculated, making it impossible to use them directly.
So the answer is Option B: False

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous