Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?

Answer Posted / srinivas

HAVING CLAUSE is used for evaluating a condition with an
aggregate function, i.e., GROUP BY whereas WHERE CLAUSE is
used for general conditions.

Is This Answer Correct ?    35 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1956


What types of replication are supported in sql server?

1115


What are triggers? How do you invoke a trigger on demand?

1364


Mention the different types of triggers?

1202


What is named calculation? : sql server analysis services, ssas

1024


What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1329


Explain what are various ways to enhance the ssrs report?

1097


Is it true, that there is no difference between a rule and a check constraint?

1110


What does REVERT do in SQL Server 2005?

1012


Explain the difference between cross join and full outer join?

1033


What is sqlcmd?

1136


What is service broker?

1062


What are parameterized reports? What are cascading parameters in ssrs reports?

165


What is the maximum size of column in sql server?

942


Explain filtered indexes benefits?

1042