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

If no size is defined while creating the database, what size will the database have?

1036


What is use of except clause?

1142


We need to perform what steps in the following order to work with a cursor?

1274


Can we write ddl in trigger?

970


How to make remote connection in database?

1050


what is a self join? Explain it with an example? : Sql server database administration

1002


What is efficiency data?

1004


How to locate and take substrings with charindex() and substring() functions?

1074


Explain the benefits of user-defined functions?

1124


What do you understand by a stored procedure?

1153


What are the different type of replication in sql server?

1016


Explain “@@rowcount” and “@@error” in sql server?

1132


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

1218


What is a heap?

1084


What do you understand by a view? What does the with check option clause for a view do?

1058