Which clause is specifically used to place a condition on groups created by…

2026

Which clause is specifically used to place a condition on groups created by the GROUP BY clause, rather than individual rows?

Answer: B. HAVINGThe HAVING clause is specifically used to place a condition on groups created by the GROUP BY clause. While the WHERE clause filters individual rows before…

  1. A.

    WHERE

  2. B.

    HAVING

  3. C.

    WHEN

  4. D.

    LIMIT

Attempted by 1144 students.

Show answer & explanation

Correct answer: B

The HAVING clause is specifically used to place a condition on groups created by the GROUP BY clause. While the WHERE clause filters individual rows before grouping occurs, the HAVING clause applies conditions after aggregation has taken place.

Explore the full course: Hpsc Pgt Computer Science

Loading lesson…