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 HAVING clause and the WHERE
clause?

Answer Posted / vivek kumar

where clause is used for conditional retriving but having
clause is used to test some condition on the group with the
help of aggregate function.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is set nocount on and what is set nocount off?

925


What are logical/boolean operations in ms sql server?

1016


Can you explain what is the use of custom fields in report?

1041


How to download microsoft sql server 2005 express edition?

1029


What is database mirroring?

1093


What is repeatable read?

989


Explain various data region available in ssrs with their use?

910


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1880


Is ssrs support other database except ms sql server?

139


What is difference between getdate and sysdatetime in sql server 2008?

1040


Which database stores information about replication?

1036


What are different types of subquery?

1215


List some major differences between triggers and stored procedures?

895


Explain the different types of joins?

969


Do you know how to implement service broker?

916