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

Where Clause------------------ It is used to Filter Rows
(i.e Restrict Rows and It appiles to the Individual Rows).

Having Clause----------------- It appies on Groups (i.e
Aggregate Functions).

Is This Answer Correct ?    23 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a dynamic performance view in oracle?

975


Explain about achiever in sql?

1008


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2601


How to add a new column to an existing table in oracle?

1115


How to run the anonymous block again?

1106


How do I use os authentication with weblogic jdriver for oracle and connection pools?

1028


How can we force the database to use the user specified rollback segment?

1114


what is difference between sql plus and sql*plus? (not sql and sql plus).

3871


How a tablespace is related to data files?

1088


How to check the oracle tns settings?

1025


How to connect asp pages to oracle servers?

1051


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2246


What are the attributes of cursor?

1029


Explain the use of indexes option in imp command.

1149


How to define an oracle sub procedure?

1114