HAVING CLAUSE and WHERE CLAUSE in SQL Server

Vipendra Verma

14y3.3k

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

Thank you.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
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.
0
Satyapriya Nayak14y ago
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
0
Vilas Gite14y ago
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

Thanks..:)
0
Hardik Patel14y ago
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.

0
Santhosh Kumar Jayaraman14y ago
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
0