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 transaction server implicit?

1007


How to change parameter value inside the report?

164


What are key constraints?

972


What is optimization and its types?

971


What are the advantages of using stored procedures in sql server?

1011


What do you understand by sql server agent?

976


What are data files?

1039


Explain difference between cross join and full outer join?

1005


Which Model uses the SET concept

984


What it means to be triggered?

1000


What is the difference between char, varchar and nvarchar?

1022


What are the different types of columns types constraints in the sql server?

1080


Where sql server usernames and passwords are stored in a sql server?

989


Explain what is meant by replication of database?

1030


What is PROJECTION Operation?

1020