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 is a mixed extent? : Sql server administration

1075


How is table type constraint applied to a table?

961


Explain four layers of abstraction microsoft architectured?

147


How can we use ConnectorJ JDBC Driver with MS SQL?

981


How many columns can we include on clustered index ?

967


What are the difficulties faced in cube development? : sql server analysis services, ssas

1018


What is read uncmmited?

1039


What are the dis_advantages of stored procedures, triggers, indexes?

2202


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2007


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

967


How to create “dependant” parameter “make, model, year”

129


What is difference between foreign key and unique key?

994


Explain system functions or built-in functions? What are different types of system functions?

953


What is the purpose of indexing?

1026


What are different types of data sources?

992