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 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.
Hi, it looks like you're using AdBlock :(
Displaying ads are our only source of revenue. To help Teachoo create more content, and view the ad-free version of Teachooo... please purchase Teachoo Black subscription.
Please login to view more pages. It's free :)
Teachoo gives you a better experience when you're logged in. Please login :)
Solve all your doubts with Teachoo Black!
Teachoo answers all your questions if you are a Black user!