MVSFORUMS.com :: View topic - Retrieving duplicates

MVSFORUMS.com Forum Index

MVSFORUMS.com
A Community of and for MVS Professionals

FAQ

Register

Log in to check your private messages

Retrieving duplicates

printer-friendly view

MVSFORUMS.com Forum Index -> Interview Q & A

View previous topic :: View next topic

Author

Message

adarsh444
Beginner

Joined: 19 Sep 2006
Posts: 13
Topics: 9

Posted: Sat Oct 14, 2006 5:06 am Post subject: Retrieving duplicates

Reply with quote

I have the data in table as

Code:

NUMBER Ver Code Eff Dt
*****************************
0710001 00 00008 2005-04-12
0710002 00 00015 2005-04-12
0710003 00 00017 2005-04-12
0710003 00 00028 2005-04-11
0710004 00 00028 2005-04-12
0710005 00 00112 2005-04-12
0710007 01 00008 2005-04-12
0710007 01 00015 2005-04-12
0710008 01 00017 2005-04-12
.....
......
......

*****************************

i want to retrieve the duplicates of NUMBER from the table having count greater than 100.Hope i'll get quick reply..

Thanks in advance....

Send private message

kolusu
Site Admin

Site Admin

Joined: 26 Nov 2002
Posts: 12360
Topics: 75
Location: San Jose

Posted: Sat Oct 14, 2006 6:34 am Post subject:

adarsh444, Please search before posting. Check this lnk http://www.mvsforums.com/helpboards/viewtopic.php?t=7219&highlight=count Hope this helps... Cheers Kolusu _________________ Kolusu - DFSORT Development Team (IBM) DFSORT is on the Web at: www.ibm.com/storage/dfsort www.linkedin.com/in/kolusu

Send private message

Send e-mail

Visit poster's website

Display posts from previous:

	MVSFORUMS.com Forum Index -> Interview Q & A	All times are GMT - 5 Hours
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group