Question

SQL applies conditions on the groups through which clause after groups have been formed?

• A. Group by
• B. With
• C. Where
• D. Having

Hint:

Use the "HAVING" clause to filter results after grouping them with "GROUP BY". "WHERE" applies conditions before grouping.

Answer 1

The Correct Option is D

In SQL, the "HAVING" clause is used to apply conditions on groups created by the "GROUP BY" clause. The "WHERE" clause is used to apply conditions on individual rows before grouping. Thus, "HAVING" is the correct choice for applying conditions after grouping the data.