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 and where clause?

Answer Posted / vinay singh

We can't use Where clause with aggregate function and Having
clause always use with aggregate function.

**Vinay Singh

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When you should use a low fill factor?

1036


define and explain the differences between clustered and non-clustered indexes.

1253


What are horizontal and vertical scaling?

172


How can we improve performance by using SQL Server profiler?

1108


What is user-defined multi-statement table-valued function?

1120


What are the different types of data sources in ssrs?

203


Explain the third normal form(3nf)?

982


how to trace the traffic hitting a sql server? : Sql server database administration

1954


What is the difference between varchar and nvarchar datatypes?

1142


How to modify the underlying query of an existing view?

1030


What happens when converting big values to numeric data types?

1228


What is a data source or ds? : sql server analysis services, ssas

1052


Explain about merge replications?

1081


How to filter out duplications in the returning rows in ms sql server?

1216


Tell me something about security and sql azure?

116