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

Do you know the capabilities of cursors?

1075


What stored by the msdb? : sql server database administration

952


What is in place upgrade in sql server?

988


What are the differences between stored procedure and view in sql server?

1159


Explain query editor regions

1003


What is a field in a table?

983


What is a self join in sql server?

1054


What are the system database in sql server 2008?

975


How to find the service pack installed? : sql server database administration

971


Tell me what are cursors and when they are useful?

909


What are the encryption mechanisms in sql server?

968


What is the guest user account in sql server? What login is it mapped to it? : sql server security

1006


What is difference between delete & truncate commands?

1023


what are isolation levels? : Sql server database administration

911


If you want to send some data from access database to sql server database. What are different component of ssis will you use?

919