Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Fetching unique records
Goto page Previous  1, 2
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
ashimer
Warnings : 1
Active User


Joined: 13 Feb 2004
Posts: 113
PostPosted: Tue Apr 22, 2008 7:07 pm    Post subject:
Reply with quote
Hi Soundarr,

try adding one more row with values say ..

Col1 Col2 Col3
-----------------
2 b iii

this time you wont get the desired o/p without DISTINCT ...

thanks,
ashimer
Back to top
View user's profile Send private message
References
PostPosted: Tue Apr 22, 2008 7:07 pm    Post subject: Re: Reply with quote
soundarr

New User


Joined: 17 Jan 2008
Posts: 9
Location: Chennai
PostPosted: Wed Apr 23, 2008 5:15 pm    Post subject:
Reply with quote
Hi Ashimer,

Distinct matters! I actually had another predicate in the WHERE clause which made me get the desired result. Thanks a lot!

Regards,
Soundarr
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 HoursGoto page Previous  1, 2
Page 2 of 2