Question

In SQL, which clause is used to filter groups of rows after aggregate functions (such as SUM, COUNT, or AV

Q: Answer-In SQL, which clause is used to filter groups of rows after aggregate functions (such as SUM, COUNT,...

The HAVING clause filters groups of rows based on the result of an aggregate function, applied after GROUP BY has formed the groups. WHERE filters individual rows before any grouping or aggregation occurs, so it cannot reference aggregate results. GROUP BY organizes rows into groups but does not filter them, ORDER BY sorts the final result set, and DISTINCT removes duplicate rows.