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

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

1029


What is the query and subquery?

1121


What do you mean by an execution plan?

1188


Define compound operators?

964


Define ACID properties in a Database?

1102


System variable and temporary variables

2299


Why use “pivot” in sql server?

1176


What are scalar functions in sql?

1208


What are the approximate numeric data types?

986


What is a trace frag?

1134


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

2051


List the different types of joins?

1057


Is there any difference between primary key and unique with the not null condition?

1001


How to verify a login name with sqlcmd tool?

1265


Explain the dbcc pintable command when would you use it?

968