difference between when clause and a having clause

arindambanerjee · New User Joined: 30 Jun 2007 Posts: 5 Location: noida

hii,
can any one explain me the difference between where clause and a having clause with an example. i mean where to use each of them and in which situations other than the fact that we need to use groupby in case of having.
i have gone through the materials but i couldn't find the exact difference and the exact circumstances in which we should use.

thanks in advance.[/i]

dick scherrer · Posted: Sat May 10, 2008 11:53 pm Post subject:

Hello,

Usually we have a requirement and look for a solution. You appear to have found some solution and are trying to look for a requirement to use it.

WHERE specifies one or more columns. HAVING specifies a result table.

Are you familiar with the "IBM Manuals" link at the top of the page? Several sets of DB2 documentation are available there. These (as well as the other sets of documentation) are your friend

Here's a link to what i believe will help you:http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqj10/4.2.5?

If you have a requirement, and post it, someone may have suggestions.

the_gautam · Posted: Sun May 11, 2008 6:28 am Post subject:

WHERE clause is used to select the matching rows according to a condition.

HAVING clause is used to select the matching rows according to a condition to form a GROUP.