Check sibling questions

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)

Are ads bothering you?


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 - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.