|
View previous topic :: View next topic
|
| Author |
Message |
arindambanerjee
New User
Joined: 30 Jun 2007
Posts: 39
Location: India
|
|
|
|
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] |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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. |
|
| Back to top |
|
|
the_gautam
Active User
Joined: 05 Jun 2005
Posts: 165
Location: Bangalore
|
|
|
|
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. |
|
| Back to top |
|
|
|
|
