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

What are the various types of snapshots ?

1027


How do I know if oracle is installed on windows?

931


What are the attributes that are found in a cursor?

1073


How to select some rows from a table in oracle?

1076


What is index-organized table in Oracle?

1069


How a database is related to tablespaces?

1031


How do I recompile a procedure in oracle?

964


Which is better Oracle or MS SQL? Why?

4939


How to join two tables in a single query using oracle?

995


How to use "out" parameter properly?

1080


How do you bind variables in oracle?

980


What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2353


How to bring a tablespace online?

1079


How to build data dictionary view an new database?

1009


What are the differences between blob and clob in oracle?

1089