SQL applies conditions on the groups through ______ clause after groups have…
2025
SQL applies conditions on the groups through ______ clause after groups have been formed.
Answer: B. having — In SQL, the HAVING clause is used to apply conditions on groups after they have been formed by the GROUP BY clause. Unlike the WHERE clause, which filters…
- A.
where
- B.
having
- C.
new
- D.
all
Attempted by 2215 students.
Show answer & explanation
Correct answer: B
In SQL, the HAVING clause is used to apply conditions on groups after they have been formed by the GROUP BY clause. Unlike the WHERE clause, which filters rows before grouping, HAVING filters the groups themselves based on aggregate conditions (e.g., COUNT, SUM, AVG). This makes HAVING the correct choice for applying conditions on groups.
Loading lesson…