what is the diff between a HAVING CLAUSE and a WHERE CLAUSE?

Posted by Majith on 7/24/2008 | Category: Sql Server Interview questions | Views: 12775

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

You can use Having Clause with the GROUP BY function in query and WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What’s the difference between // comments, /* */ c ...

Next > : How many types of cookies are there in ASP.NET ?

Comments or Responses

More Interview Questions by Majith

How many types of cookies are there in ASP.NET ?
Types of Errors ?
What event handlers can I include in Global.asax?
What are the remotable and non-remotable objects in .Net Remoting.
Describe the type of remotable objects in .Net Remoting.
Describe the term Channel in .Net Remoting
What is Code group?
What happens if you inherit multiple interfaces and they have conflict ...

Latest Interview Questions

How to convert an ArrayList into an Array?
How to convert an Array into an ArrayList?
How to get the authentication mode from web.config file programmatical ...
How to clear the last error occured in the application?
How to retrieve the last error occured in the application?
How to load a user control dynamically in runtime?
What are the validation controls in asp.net?
Which two properties are on every validation control?
More ...