HAVING CLAUSE and WHERE CLAUSE in SQL Server

Question

I want to know what is the difference between a HAVING CLAUSE and WHERE CLAUSE in SQL server. Thank you.

Jignesh Trivedi · Answer

Hi, both, WHERE and HAVING clauses allow us to restrict the data you're selecting by establishing conditions. Use HAVING instead of WHERE when you want to establish a condition that involves a grouping (aggregating) function like count(), max(), sum(), etc. The WHERE clause is applied first to the individual rows in the tables Please refer http://www.codeproject.com/Articles/25258/Where-Vs-Having-Difference-between-having-and-Wher http://blog.sqlauthority.com/2007/07/04/sql-server-definition-comparison-and-difference-between-having-and-where-clause/ http://www.techonthenet.com/sql/having.php hopr this will help you.

Satyapriya Nayak · Answer

Hi Vipendra, 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

Vilas Gite · Answer

Hi Vipendra Just Watch & Implement queries. http://www.youtube.com/watch?v=0EgAxYv-44o http://www.w3schools.com/sql/sql_having.asp http://www.w3schools.com/sql/sql_groupby.asp T hanks..:)

Hardik Patel · Answer

Vipendra, 1) where clause specifes the criteria which individual record must meet to be selected by query. it can be used without GROUP BY Clause. the HAVING Clause can not be used without GROUP BY Clause . 2) where clause can not contain aggregate function. Havng clause can contain aggregate function.

Santhosh Kumar Jayaraman · Answer

HAVING specifies a search condition for a group or an aggregate function used in SELECT statement. 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. A HAVING clause is like a WHERE clause, but applies only to groups as a whole, whereas the WHERE clause applies to individual rows. A query can contain both a WHERE clause and a HAVING clause. The WHERE clause is applied first to the individual rows in the tables . Only the rows that meet the conditions in the WHERE clause are grouped. The HAVING clause is then applied to the rows in the result set. Only the groups that meet the HAVING conditions appear in the query output. You can apply a HAVING clause only to columns that also appear in the GROUP BY clause or in an aggregate function. Reference: BLOG.SQLAUTHORITY

HAVING CLAUSE and WHERE CLAUSE in SQL Server

Answers (5)