Archived discussions are read-only. Learn more about SAP Q&A

removing duplicate entries from database table

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

Not what you were looking for? View more on this topic or Ask a question