Difference between HAVING Clause and WHERE Clause

Below are few differences between HAVING Clause and WHERE 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


If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


Interesting BlogPosts to read

Difference between Any() and Count() in LINQ
Most of the developers would have come across Any() and Count() when using LINQ in C# . What is diff...
SingleOrDefault vs. FirstOrDefault in LINQ
The LINQ (Language Integrated Query) has the extension methods SingleOrDefault and FirstOrDefault . ...
What is the difference between IEnumerable and IQueryable in C# ?
If you are a C# developer and work with collections as well as LINQ/Entity Framework , you would hav...