Deleting n rows among m duplicated rows

sailaja.sn · New User Joined: 14 Jul 2008 Posts: 4 Location: Chennai

Hi,

My table contains some m duplicate rows . My requirement is to delete only n rows among those m duplicated rows.

To be more clear, please see the sample data:

TableA:
===============
ID Name Garde
==================
1 aaaa a1
1 aaaa a1
1 aaaa a1
2 bbbb b1

If we have used "delete from table where name = 'aaaa' " then it will delete all the rows with 'aaaa'.But my requirement is to keep a single row with 'aaaa' and delete all the other 2 'aaaa' rows that are duplicated.

Is there any way in resolving this issue.

Thanks & regards,
Sailaja

dbzTHEdinosauer · Posted: Mon Aug 04, 2008 5:47 pm

unload the table, process the qsam file, reload the table.

dick scherrer · Posted: Mon Aug 04, 2008 9:35 pm

Hello,

You might declare a cursor, fetch the "first" aaaa row and ignore it, fetch the others (if any) and delete them.