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

Understanding the SQL HAVING Clause

The SQL HAVING clause is specifically used to filter results after an aggregation has been performed on a set of rows. It is typically used in conjunction with the GROUP BY clause, allowing users to impose conditions on the grouped records.

Analysis of Options

1. To filter rows from a table: This describes the functionality of the WHERE clause, not HAVING.
2. To filter rows after grouping: Correct. HAVING is used to filter groups created by GROUP BY based on aggregate functions.
3. To join two or more tables: This is the role of JOIN statements, not HAVING.
4. To sort rows in a table: The ORDER BY clause is utilized for sorting, not HAVING.

Conclusion

Based on the analysis, the correct answer is:

To filter rows after grouping.