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

How to select some columns from a table in oracle?

1005


Write a trigger example in oracle?

983


What privilege is needed for a user to query tables in another schema?

922


How to convert numbers to characters in oracle?

971


Explain what are the advantages of views?

1014


Explain the types of exception?

1083


What is a proxy class?

969


Why should I use oracle database?

948


Explain the use of owner option in exp command.

994


Why do you create or replace procedures rather that drop and recreate.

948


How to start your 10g xe server from command line?

1001


Explain the difference between a procedure and a function? What do you understand by those terms?

1023


How to install oracle database 10g xe?

967


What is blob data type in oracle?

1049


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2302