Which of the following is true about the HAVING clause ?

Question

Accepted Answer

The correct option is (3):
The HAVING clause is a crucial component of Structured Query Language (SQL) used in conjunction with the GROUP BY clause. While the WHERE clause filters individual data records (or rows) *before* any grouping or aggregation takes place, the HAVING clause is specifically designed to filter the summary output or *groups* that are produced *after* the GROUP BY clause has executed and aggregate functions (like SUM, COUNT, AVG) have been calculated. Essentially, you use WHERE to eliminate unwanted individual data records, and you use HAVING to eliminate unwanted aggregate groups based on a calculated condition, such as only showing departments where the total employee count is greater than 10. The statement is true because the HAVING clause operates at the group level, making it the tool for filtering aggregated data.

The incorrect option is (1):
This statement is incorrect because the HAVING clause's primary function is not to filter columns, but to filter *groups*. The projection, or selection, of columns is handled by the SELECT clause. While the HAVING clause’s conditions often involve aggregate functions applied to columns, the filtering is performed on the resulting groups of data. The WHERE clause also filters individual *rows*, not columns, so the comparative logic presented in this option is fundamentally flawed.

The incorrect option is (2):
This option incorrectly describes the key functionality of the HAVING clause. The WHERE clause is indeed used for filtering individual rows, but the HAVING clause is used to filter the aggregated results, which are known as *groups*. Therefore, stating that the HAVING clause is used for filtering "rows rather than columns" is an inaccurate definition of its role in an SQL query structure. The core distinction remains filtering rows (WHERE) versus filtering groups (HAVING).

The incorrect option is (4):
The HAVING clause does *not* act exactly like a WHERE clause; their difference is a foundational concept in SQL. The WHERE clause is processed much earlier in the query execution and can only apply conditions to raw, individual row data. It cannot, by design, contain aggregate functions in its conditions because aggregation has not yet occurred. The HAVING clause, conversely, is processed *after* aggregation and is specifically designed to apply filtering conditions directly to the results of aggregate functions on the grouped data.