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 / shashikant

in 'where' clause every records filtered based on where
in 'having' is with aggregate records (group by functions )

Is This Answer Correct ?    44 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to insert comments into sql statements return in the data model editor ?

2557


Explain the truncate in oracle?

966


How to create a single index for multiple columns?

1037


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1042


How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1074


What is an oracle transaction?

1144


How to create tables for odbc connection testing?

1117


What are the different types of database objects?

1062


What is a read write transaction in oracle?

1089


How to convert times to characters in oracle?

1027


hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999


How does the on-delete-cascade statement work?

1102


What is proxy method?

971


What is sharded cluster?

1014


What are the restrictions in a oracle read only transaction?

1032