Which clause is used to "filter out unwanted Groups"?
A. HAVING
B. FROM
C. WHERE
D. SELECT
Answer: Option A
Solution (By Examveda Team)
This question is about filtering data in SQL, specifically when you are working with groups of data (like using the GROUP BY clause).The HAVING clause is used to filter out unwanted groups. It works like the WHERE clause, but it applies to the results of the GROUP BY operation.
Here's a breakdown of the options:
* Option A: HAVING - Correct! This is the clause used to filter groups. * Option B: FROM - This clause specifies the table you want to retrieve data from. * Option C: WHERE - This clause filters individual rows before grouping. * Option D: SELECT - This clause specifies the columns you want to retrieve.
So, the answer is Option A: HAVING.

Join The Discussion