Multiple choice technology databases

The HAVING clause can be used only with ...

  1. INSERT clause

  2. SELECT clause

  3. DELETE clause

  4. JOIN clause

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The HAVING clause is used to filter groups of rows created by the GROUP BY clause, which is a component of a SELECT statement. It cannot be used with INSERT, DELETE, or JOIN clauses directly, as they do not support group-level filtering.