Multiple choice technology databases

The HAVING clause can be used only with

  1. DELETE clause

  2. INSERT clause

  3. SELECT clause

  4. JOIN clause

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

The HAVING clause filters aggregated results and can only be used with SELECT statements that include GROUP BY. While WHERE filters individual rows before aggregation, HAVING filters groups after aggregation. HAVING cannot be used with DELETE, INSERT, or alone - it requires a SELECT query context.