Delete duplicate records from a table.

prashanth1 · New User Joined: 27 Sep 2006 Posts: 47 Location: Hyderabad

I have a requirment that to delete all the duplicate records expect the first record from the table.

Assume that I have 5 reords all are duplicate. I want to delete 4 duplicate records only.

guptae · Posted: Wed Apr 07, 2010 2:43 pm

Hello Prashanth,

Please use the forum search facility before posting new thread. Topic has been discussed so many times in recent past.

www.ibmmainframes.com/viewtopic.php?t=47351&highlight=delete+duplicate
www.ibmmainframes.com/viewtopic.php?t=43821&start=0

Manshadi · New User Joined: 31 Aug 2005 Posts: 82

If you don't have more data you can use REPAIR utility for this purpose as follow :

First of all run rebuild utility for finding duplicate records .
and after that use repair utility with delete option for deleting duplicate records.

Regards
Manshadi