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
 
How to get duplicate field records from table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
aryanpa1

New User


Joined: 26 May 2007
Posts: 17
Location: Chennai
PostPosted: Thu Oct 16, 2008 9:51 pm    Post subject: How to get duplicate field records from table
 Reply with quote
Hi Team ,

How can we retrieve the rows in which particular field is repeated more than n times.

For Example.
Code:
STU_NAME STU_NUMBER STU_MARKS
 AAAAA-----11111----------50
 BBBBB-----22222----------50
 CCCCC----33333----------60
 DDDDD----44444----------50
 EEEEEE-----55555----------60

In this scenario I need to get the rows which are having same marks for more than 2 rows.

Expected rows are with STU_NAME s AAAAA,BBBBB,DDDDD

Edited: Please use BBcode when You post some code, that's rather readable...Anuj
Back to top
View user's profile Send private message
References
Anuj D.

Global Moderator


Joined: 22 Apr 2006
Posts: 2352
Location: Mumbai, India
PostPosted: Fri Oct 17, 2008 12:21 am    Post subject:
Reply with quote
Hi,

Check this link: http://ibmmainframes.com/viewtopic.php?t=33912&highlight=duplicate
Back to top
View user's profile Send private message
aryanpa1

New User


Joined: 26 May 2007
Posts: 17
Location: Chennai
PostPosted: Fri Oct 17, 2008 12:55 am    Post subject:
Reply with quote
Thank you Anuj. It is working.
Back to top
View user's profile Send private message
Anuj D.

Global Moderator


Joined: 22 Apr 2006
Posts: 2352
Location: Mumbai, India
PostPosted: Fri Oct 17, 2008 2:07 am    Post subject:
Reply with quote
You're welcome.. icon_smile.gif

-Ad
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 Hours
Page 1 of 1