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 difference between having and where clause ?

Answer Posted / raju

Having clause is applied only to the group by function
where as where clause is applued to each and every row in a
table

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a collation in ms sql server?

1083


What is a benefit of using an after insert trigger over using a before insert trigger?

981


How to generate create view script on an existing view?

986


What is data source view or dsv? : sql server analysis services, ssas

1000


Explain syntax for viewing, dropping and disabling triggers?

949


What is default constraint?

995


What is the size of transaction log file?

924


Distinguish between nested subquery and correlated subquery?

1040


What command is used to create a database in the sql server and how?

1174


what is a mixed extent? : Sql server administration

1096


What is serializable?

1039


what protocol both networks use? : Sql server database administration

967


How to run sql server 2005 books online on your local system?

957


Why I am getting "the microsoft .net framework 2.0 in not installed" message?

976


What is update locks?

881