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 / senthil kumar t

Where clause is used for conditional retreiving from the
table and also aggregate functions can be used in where
clause. Having clause will be used for the recordset this
also supports the aggregate functions

Is This Answer Correct ?    10 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

113


How to create indexed view?

1105


What is the architecture of ms sql reporting service?

1026


What is clustered primary key?

1082


How many triggers you can have on a table?

1033


please differentiate between delete and truncate?

1038


How data can be copied from one table to another table?

1003


What does the update command do?

1173


What is the difference between ‘having’ clause and a ‘where’ clause?

1086


What is the full form of dql?

1025


Explain what is raid and what are different types of raid levels?

1088


Why olap is used?

1034


Describe the functionalities that views support.

1146


How to turn off warning messages during php execution?

1106


What stored procedure would you use to view lock information?

1017