Difference between HAVING Clause and WHERE Clause

Below are few differences between HAVING Clause and WHERE Clause

HAVING Clause

• HAVING Clause is used for aggregating or grouping
• It is mostly used along with the GROUP BY Clause
• Can only be used with Select Statement

WHERE Clause 

• WHERE Clause is used for filtering individual records
• Can be used with SELECT, UPDATE and DELETE Statement