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 covering index?

985


Why truncate is ddl command?

1066


What are the new features of sql server 2012 reporting service?

133


Tell me what are cursors and when they are useful?

956


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

931


What are scalar functions?

1000


What is analysis service repository?

1023


Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1051


Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

990


What is PROJECTION Operation?

1022


How can sql server instances be hidden? : sql server security

1151


Explain subquery and state its properties?

1043


What does it mean if @@cursor_row returns a negative number?

992


Can we use where clause in union?

1069


How do I install only the client tools of sql server 2000?

1067