Question 5 - MCQ Questions - Chapter 9 - Structured Query Language

Last updated at July 14, 2026 by

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)

Remove Ads
Teachoo · Class 12 Explore Class 12

Transcript

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)

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh is an IIT Kanpur graduate and has been teaching for 16+ years. At Teachoo, he breaks down Maths, Science and Computer Science into simple steps so students understand concepts deeply and score with confidence.

Many students prefer Teachoo Black for a smooth, ad-free learning experience.