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 / kundan ravi

having clause alwaye use with aggregate functions and where
clause use for conditions but not with aggregate functions.

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of table joins?

1003


Can a synonym name of a table be used instead of a table name in a select statement?

1028


What do you mean by data manipulation language?

1014


How important do you consider cursors or while loops for a transactional database?

962


How to fine-tune reports?

266


What is the purpose of indexing?

1044


What are wait types?

1110


Who developed sql server?

936


List all types of constraints in sql server?

1028


Do you know how to store and query spatial data?

1038


What is GUID in sql server?

1161


What is trace flag in sql server?

1018


what is the difference between Delete and Truncate command in SQL

1147


How to truncate the log in sql server 2012? : sql server database administration

1283


What is the impact on other user sessions when creating indexes?

923