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

 

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.
Pin It

Leave a Reply

Your email address will not be published. Required fields are marked *