Multiple choice technology databases

What does the HAVING clause do?

  1. The HAVING keyword specifies a search condition for an aggregate or a group

  2. The HAVING keyword is used to select distinct values

  3. The HAVING keyword is used to join 2 or more tables.

  4. None of the above

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

The HAVING clause in SQL is used to specify search conditions for groups or aggregate functions, typically following a GROUP BY clause. The WHERE clause filters individual rows, whereas HAVING filters aggregated results.