5 Replies Latest reply: Sep 22, 2010 12:06 PM by boby thankachen RSS

removing duplicate entries from database table

Amit Majumder
Currently Being Moderated

Hi All,


Requirement is that we have a database table tab1 like this

id   name        address

1    AA1          X

1    AA1          X

2    AA2           Y

2    AA2           Y


and we have to insert this data of tab1 into tab2 in this form

id   name      address

1    AA1         X

      AA1         X

2    AA2         Y

      AA2           Y


all the duplicate ids are removed .


How an we do this . Please suggest.



ABAP Developer1