What is different between where and Having clauses

Question

describe in detail about where and having clause and also differentiate it.

Shankar M · Answer

Hi Sathya Prakash Where and Having Clause are use as filter the record groups based on the condition which we specify. The Having Clause is usually used with a aggregate functions in sql. Thanks Shankar

Satyapriya Nayak · Answer

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.

Vishnujeet Kumar · Answer

http://blog.sqlauthority.com/2007/07/04/sql-server-definition-comparison-and-difference-between-having-and-where-clause/ http://www.programmerinterview.com/index.php/database-sql/having-vs-where-clause/