Question

The HAVING clause does which of the following?

A. Acts like a WHERE clause but is used for groups rather than rows.
B. Acts like a WHERE clause but is used for rows rather than columns.
C. Acts like a WHERE clause but is used for columns rather than groups.
D. Acts EXACTLY like a WHERE clause.

Answer 1

The HAVING clause in SQL acts like the WHERE clause but is used for filtering groups created by the GROUP BY clause, rather than individual rows.

Step-by-step explanation:

The HAVING clause is used in SQL and acts like a WHERE clause but is specifically used for groups created by the GROUP BY clause, rather than for individual rows. This allows you to specify conditions that filter which group results appear in the final output. For example, if you want to find departments with a total salary greater than a certain amount, you would use GROUP BY to group the rows by department and HAVING to apply the condition on the grouped rows.

Correct Answer is: A. Acts like a WHERE clause but is used for groups rather than rows.