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

Is natural join and equi join same?

1030


What is the difference between a "where" clause and a "having" clause?

1210


What is difference between sql and sql server?

1081


What does truncate do?

993


Is sql server free?

974


Why main is user defined function?

1051


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

1027


How can delete duplicate records in cte in sql server?

1014


What is pessimistic concurrency?

1023


Mention the different types of replication in sql server.

1070


Do you know the cursor optimization tips?

1038


When would you prefer to have a minimum number of indexes?

960


What are the different types of cursor?

1149


How do I find information about the install locations for the various instances running on a computer?

1123


Does view occupy space?

991