Where Vs Having Clause
Where Condition or Clause:
1. it is more fast.
2. we can use this condition with out group by clause.
3. this condition can not contain aggregate functions.
4. This clause select the rows before grouping of records.
5. Where condition can operate on individual row.
Having Clause:
1) It is much slow.
2) We can't use this condition with out group by clause.
3) This caluse can contain aggregate functions.
4) HAVING clause select rows after grouping.
5) HAVING clause can operate group of row.
This is one of the good SQL Server Interview Question.
Post a Comment
Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.