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

WHERE filters the rows based on the predicate.
HAVING filters a group of rows based on the GROUP BY colums.

Is This Answer Correct ?    48 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define declaration generator (dclgen).

1172


What is dclgen in db2?

1199


What is check constraint in db2?

1164


Name the lockable units in DB2?

1187


Highlight all the advantages that are attached to a package.

1169


What is isolation level in db2?

1069


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

8381


What is a page in db2?

1074


What is the maximum No of rows per page?

1116


How to access db2 tables in mainframe?

1103


How to execute stored procedures?

1176


Explain the function of data manager.

1097


Is ibm db2 open source?

1132


When the like statement is used?

1281


If I have a view which is a join of two or more tables, can this view be updateable?

1185