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 HAVING clause and the WHERE
clause?

Answer Posted / pallavi tiwari

in where clause the data that fetched in memory is according
to condition but in having the completed data firstly
fetched in memory and then seperated according to condition.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1038


What is snapshot replication?

1096


Explain iaas, paas and saas?

92


How to count rows with the count(*) function in ms sql server?

1057


How many levels of sp nesting is possible?

1099


What are the advantages of using a stored procedure?

1052


What is checkpoint in sql server?

1214


What is difference between count (*) and count 1?

969


What happens if we shrink log file in sql server?

1029


what is package and it uses and how can u call a package

2065


What is the difference between getdate and sysdatetime?

1060


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1100


Determine how to use the inserted and deleted pseudo tables?

1038


Which are the new data types introduced in sql server 2008?

925


Can you explain what is indexed view? How to create it?

944