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 / guest

Having Clause is basically used only with the GROUP BY
function in a query. WHERE Clause is applied to each row
before they are part of the GROUP BY function in a query.

Is This Answer Correct ?    68 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is nonclustered index

961


What is SubQuery in SQL Server 2008

1023


what are different types of backups available in sql server? : Sql server database administration

938


What is the security model used in sql server 2005?

1010


Explain about system stored procedure?

1034


what is a join and explain different types of joins? : Sql server database administration

959


Where views are stored in sql server?

986


Explain the database you used in your final year project?

1045


What are the differences between decimal and float in ms sql server?

1247


Explain multiserver query

1046


let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

953


What is dynamic cursor in SQL SERVER?

1082


What are the advantages of the mirroring?

1094


What is intellisense?

1053


I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1120