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

What are statistics?

999


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1875


How to disable stored procedure sql server?

1606


What are the difference between clustered and a non-clustered index?

1043


How many types of cursor type are there?

1090


How to write a query with a right outer join in ms sql server?

913


How to convert character strings into numeric values?

1096


What is the use of set nocount on/off statement?

1097


What is a collation in ms sql server?

1085


What is difference between rollback immediate and with no_wait during alter database?

1090


What are partitioned views and distributed partitioned views?

1022


What is multi-statement table-value user-defined function?

996


Explain the xml support sql server extends?

1041


What are the steps to process a single select statement?

942


How many types of database relationship in sql server?

1054