Difference Between a HAVING CLAUSE and a WHERE CLAUSE

Question

Hi What is the difference between a HAVING CLAUSE and a WHERE CLAUSE in SQL Server ?

Jignesh Trivedi · Answer

hi please refer http://blog.sqlauthority.com/2007/07/04/sql-server-definition-comparison-and-difference-between-having-and-where-clause/ http://www.codeproject.com/Articles/25258/Where-Vs-Having-Difference-between-having-and-Wher it very good article.

Satyapriya Nayak · Answer

Hi Arun Specifies a search condition for a group or an aggregate. HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in a query. WHERE Clause is applied to each row before they are part of the GROUP BY function in a query. Thanks

Vulpes · Answer

There's a nice explanation of the difference here: https://riteshshah.wordpress.com/2009/03/05/where-and-having-clause-in-microsoft-sql-server/