Computer Science for IGCSE & O level - Databases (Section 5 - No. 16)

What is the function of the `HAVING` clause in an SQL query?
To filter the results after the `GROUP BY` clause has been applied.
To sort the result set.
To specify the columns to be selected.
To filter the results before the `GROUP BY` clause.

Explanation

The `HAVING` clause is used to filter the results after the `GROUP BY` clause is applied, which allows filtering of the aggregated data.

Comments (0)

Advertisement