Difference between HAVING Clause and WHERE Clause

SQL Server 64 Views 0 Min Read

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

 

Tags: