The __________ clause places condition with aggregate functions.
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 12 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.