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 the difference between Where and Having Clause

Answer Posted / njadav

Where Clause:
1)WHERE clause can be used without GROUP BY clause.
2)WHERE clause select rows before grouping.
3)WHERE clause can not contain aggregate functions.
4)WHERE clause can operate individual row.
5)It is more fast.

Having Clause:
1)HAVING clause can not be used without GROUP BY clause.
2)HAVING clause select rows after grouping.
3)HAVING clause can contain aggregate functions.
4)HAVING clause can operate group of row.
5)It is much slow.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which command is used to remove all rows from a table?

1114


what is the role of the cursor in db2?

1070


What is buffer pool in the db2 database?

1111


Explain db2.

1041


What is db2 stogroup?

1165


Is ibm db2 free?

1016


How to execute stored procedures?

1134


What is consistency token in db2?

1148


Name the various locking levels available?

1099


What is data manager?

1056


What is dbrm? When it will be created?

1030


What is ibm db2 client?

944


What is bind and rebind in db2?

1140


What are the bind parameters ibm db2?

1056


Highlight all the advantages that are attached to a package.

1120