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

Why is the need for data conversion transformations?

1069


can a table be moved to different filegroup? : Sql server administration

978


What is log ldf?

984


What is the stored procedure?

1009


What is the report builder?

139


what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1139


How do you check sql server is up and running?

1001


How to change server name in sql server?

1184


How many clustered indexes there can be on table ?

1039


What is an indice?

1037


What is normalization 1nf 2nf 3nf?

1060


Write a query to find 5th highest amount paid from the customer table.

934


What do you mean by stored techniques? How would we use it?

1034


How to provide values to stored procedure parameters in ms sql server?

1037


Which is the latest version of sql server and when it is released?

1112