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.

 

thanks

ABAP Developer1

Actions