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 a HAVING CLAUSE and a WHERE
CLAUSE?

Answer Posted / swati mandve

where clause is executed (for each row) first and
written before the group by statement..
having clause is strictly folllowed by groupby clause.to
filter the group.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain isolation levels that sql server supports?

1023


Explain forward - only cursors?

1034


Issues related in upgrading SQL Server 2000 to 2005 / 2008

1874


Why use “pivot” in sql server?

1089


Define Unique Key?

984


What is the default value of an integer data type in sql server 2005?

941


What are the different ways you can create databases in sql server?

1079


What are indexes in sql?

1247


Why do we need normalization?

901


What are the database objects? : SQL Server Architecture

1029


What is the difference between an index and a unique index?

984


What are user-defined functions (udfs) in sql server?

969


Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128


Can I save my report as html, excel or word? : sql server management studio

929


How to provide values to stored procedure parameters in ms sql server?

1007