i tried the same way before but it does not go in... i am not going to delete the table eventually as it is critical to keep that table without...

i tried that but it is not working....I have written code which is displayed below...

DELETE FROM dummy1

WHERE M_ItemID IN

(SELECT M_ItemID FROM dummy1

GROUP BY M_ItemID HAVING COUNT(M_ItemID) > 1)

but...

Hi,

Thank you all for your response... The main reason why i would want to go for this removal process is to make my table data look more clean and eventually...