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 / suga priya

query:WHERE DEPARTMENT > 333


query:HAVING AVG(SALARY) > 50000.

Is This Answer Correct ?    18 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a partition in oracle?

1122


Explain rename?

986


What is ASM (Automatic Storage Management) in Oracle?

1198


What do database buffers contain?

1037


Explain cascading triggers.

1077


Difference between cartesian join and cross join?

1049


Explain index?

1264


How to use "startup" command to start default instance?

1038


Does oracle charge for java?

1058


How to create a table index?

1155


what is port in oracle? how is it related to database application.

1949


What is an oracle table?

992


How to define a procedure inside another procedure?

1024


How can we create the complete backup of data in the oracle.

2161


Which is faster join or subquery in oracle?

995