Which clause must be used instead of WHERE to filter or restrict rows after an aggregation or group-by operation has been performed? MCQ with Answer and Explanation
Which clause must be used instead of WHERE to filter or restrict rows after an aggregation or group-by operation has been performed?
A. RESTRICT
B. WHEN
C. HAVING
D. WHERE CURRENT OF
Answer: Option C
Solution (By JKSSB Mock Tests)
The HAVING clause was added to SQL because the WHERE keyword cannot be applied to aggregate functions; it filters groups generated by the GROUP BY clause.
No comments yet. Be the first to start the discussion!