Cloud Training (Online)




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