Question

Which of the following is true about the HAVING clause?

Select the correct answer from below options:

a) Similar to the WHERE clause but is used for columns rather than groups.

b) Similar to WHERE clause but is used for rows rather than columns.

c) Similar to WHERE clause but is used for groups rather than rows.

d) Acts exactly like a WHERE clause.

Answer 1

c) Similar to WHERE clause but is used for groups rather than rows.

The HAVING clause is always used with the GROUP BY clause and returns the rows where the condition is TRUE.