The __________ clause places condition with aggregate functions.
(A) HAVING
(B) WHERE
(C) IN
(D) BETWEEN
Answer:
Checking the options
- (A) HAVING - It is used to place conditions on the data returned by aggregate functions.
- (B) WHERE - It is used to extract records that fulfill a specific condition.
- (C) IN - It is used to check if an expression matches with any value in a list of values.
- (D) BETWEEN - It is used to check if an expression is within a range of values.
From the above explanation, it is clear that the HAVING clause places conditions with aggregate functions.
So, the correct answer is (A)
