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
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion