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

Where clause is used prior the grouping of data,
where as Having is used after grouping the result of the
data.

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we add a cpu to sql server?

960


Explain about Normalization?

1015


Explain “row_number()” in sql server with an example?

950


What are the new data types are introduced in sql 2000?

862


Is there any difference between primary key and unique with the not null condition?

887


Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

938


What are the underflow and overflow behaviors on float literals?

1061


Do you know what are the properties of the relational tables?

983


Explain differences between web edition and business edition?

119


Difference between Logical Page and Physical Page in SSRS.

459


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

986


What is the user of Primary key?

926


How to return the second 5 rows in ms sql server?

1006


Why I can not enter 0.001 second in date and time literals in ms sql server?

1013


What are the different kinds of ssrs reports?

206