Can aggregate functions be used with HAVING clause? With WHERE clause? What is the difference between WHERE and HAVING clause? Can HAVING be used without GROUP BY?

Question

Accepted Answer

Yes, aggregate functions can be used with HAVING and WHERE clauses. WHERE filters rows before grouping, HAVING filters groups after grouping.

Aggregate functions can be used with HAVING clause to filter groups based on the result of the aggregate function.
Aggregate functions can also be used with WHERE clause to filter rows before grouping.
WHERE clause filters rows before grouping, while HAVING clause filters groups after grouping.
HAVING clause requires a GROUP BY clause, but it is possible to use HAVING without GROUP BY in some databases like MySQL.

Accepted Answer

Aggregate functions can be used with HAVING clause. Not with WHERE clause. WHERE clause comes before GROUP  BY, HAVING after it. HAVING can be used without GROUP BY in which case it will be like a WHERE clause without having the column it is referring to aggregated.

Can aggregate functions be used with HAVING clause? With WHERE clause? What is the difference between WHERE and HAVING clause? Can HAVING be used without GROUP BY?

Top McAfee Data Analyst interview questions & answers

Popular interview questions of Data Analyst

Top HR questions asked in McAfee Data Analyst