All Forums Database
dhirajpalse 36 posts Joined 01/08
03 Jul 2008
Deleting Duplicate records...

Hi,I have the following records in my multiset table:- EN ENAME----- --------------- 1 AAA 1 AAA 1 AAA 2 BBB 2 BBB I would like to delete the duplicate records and retain only distinct records i.e the table should be left with:- EN ENAME----- --------------- 1 AAA 2 BBB I am aware of the INSERT/SELECT to other table ....But I would like to know if it can be done using a single DELETEstatement.

Adeel Chaudhry 773 posts Joined 04/08
03 Jul 2008

If I am not wrong, it is in the documentation that it is not possible to delete duplicate rows in a MULTI-SET table, using just a single DELETE statement.Regards,Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

03 Jul 2008

Hi,you can change your table defination i.eyou have to change only the keyword "MULTISET" to "SET"this will automatically take distinct records and avoid duplication

You must sign in to leave a comment.