Check sibling questions

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

Last updated at May 29, 2023 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)

Learn in your speed, with individual attention - Teachoo Maths 1-on-1 Class

Book a free demo

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)

Ask a doubt
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 13 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.