What is the purpose of the SQL HAVING clause?OptionsTo filter rows from a tableTo sort rows in a tableTo filter rows after groupingTo join two or more tables

Purpose of the SQL HAVING Clause

The SQL HAVING clause is specifically designed to filter records that work on summarized GROUP BY results. It is used to restrict the results returned by the GROUP BY clause based on a specified condition.

Examining the Options:

1. To filter rows from a table: This is generally done using the WHERE clause before any grouping happens.
2. To sort rows in a table: Sorting is accomplished with the ORDER BY clause, not HAVING.
3. To filter rows after grouping: This is the correct use of the HAVING clause. It applies conditions to the aggregated data returned by the GROUP BY.
4. To join two or more tables: Joining is performed using the JOIN clause, not HAVING.

Final Answer

The correct answer is: To filter rows after grouping.