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

How to declare and use cursor variables?

1247


What is autocommit mode in sql server?

1261


How to return the date part only from a sql server datetime datatype?

1160


What is the most common type of join?

1036


How to insert and update data into a table with "insert" and "update" statements?

1038


How much space does sql server 2016 take?

1026


What are the new scripting capabilities of ssms? : sql server management studio

1114


Explain collation?

1098


Explain trigger and its types?

1111


What is normalization? What number of normalization shapes are there?

1151


Describe triggers features and limitations?

1046


How to invoke a trigger on demand?

1145


explain the storage models of olap? : Sql server database administration

1008


Explain the difference between HTTP and HTTPS in database?

1086


What is the difference between update lock and exclusive lock?

1025