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 difference between where clause and having clause?

Answer Posted / rajesh dutta

where conditions used only for comparing row values.

having conditions used to compares group values like
min,max,count etc.

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about your project and its relation to the current job position you are applying to?

1078


Can a formula column be obtained through a select statement ?

2380


How to use existing values in update statements using oracle?

1115


How to turn on or off recycle bin for the instance?

1126


What is bulk copy or bcp in oracle?

1184


How to increment dates by 1 in oracle?

1138


What is merge in oracle?

1097


Differentiate between post-database commit and post-form commit?

1092


How many types of auditing in Oracle?

1088


What is an oracle recycle bin?

1064


What privilege is needed for a user to create views in oracle?

1094


Difference between open_form and call_form in oracle.

1224


What is catalog in Oracle?

1438


How to save query output to a local file?

1087


Can group functions be mixed with non-group selection fields?

1073