What is the difference between a "where" clause and a "having" clause?

Question

Amit Singh · Answer

Difference between a Where Clause and a Having Clause Having Clause is basically used only with the GROUP BY function in a query. WHERE Clause is applied to each row before they are part of the GROUP BY function in a query. Syntax Having Clause:

interview

What is the difference between a "where" clause and a "having" clause?

Can you answer this question?

1 Answers