Rajesh
Thursday, May 18, 2017
SQL Delete duplicatie records in a table which as a primary key
delete e1.* FROM TempTable e1 INNER JOIN TempTable e2 ON e1.col1=e2.col1 AND e1.col2=e2.col2 AND e1.ID>e2.ID
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)