This is the Query to delete duplicate values from a table......
delete FROM <tablename> WHERE <tablename>.%%physloc%%
NOT IN (SELECT MIN(b.%%physloc%%) FROM <tablename> as b
GROUP BY b.columnname1,b.columnname2) and <put here your condition for table>
delete FROM <tablename> WHERE <tablename>.%%physloc%%
NOT IN (SELECT MIN(b.%%physloc%%) FROM <tablename> as b
GROUP BY b.columnname1,b.columnname2) and <put here your condition for table>
0 comments:
Post a Comment